bigquery-ai-ml
将 ML 与生成式能力直接带入 SQL，适合数据分析师快速建模与探索。
复杂查询可能产生高额费用，需关注权限与账单
在 BigQuery 中使用内建 AI/ML 函数（如 AI.FORECAST 等）进行预测、异常检测与语义搜索。
在 BigQuery 里直接写 SQL 调用内建的 AI/ML 函数（比如 AI.FORECAST、AI.DETECT_ANOMALIES、AI.GENERATE、AI.KEY_DRIVERS）来做预测、异常检测、语义/向量搜索、文本分类和摘要等分析。需要把机器学习或生成式 AI 能力嵌进数据仓库查询和报告时用它。特别之处是这些功能在 SQL 层调用并整合了 Vertex AI，无需额外训练部署模型，但不用于常规表或作业管理。
▸ 展开 SKILL.md 英文原文
Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics. Use when you need to write SQL queries that perform time-series forecasting, predict values, detect outliers or anomalies, find key drivers, perform semantic search or vector search, classify text, calculate similarity, summarize content, translate language, evaluate models, filter by semantic conditions, or leverage generative AI capabilities in BigQuery. Do not use for general BigQuery dataset, table, or job management requests.
帮我安装这个 skill：https://raw.githubusercontent.com/google/skills/main/skills/cloud/bigquery-ai-ml/SKILL.mdcurl -fsSL "https://raw.githubusercontent.com/google/skills/main/skills/cloud/bigquery-ai-ml/SKILL.md"# BigQuery AI & ML
BigQuery integrates with Vertex AI to provide powerful machine learning and
generative AI capabilities directly within SQL queries using built-in functions
like `AI.FORECAST`, `AI.KEY_DRIVERS`, `AI.DETECT_ANOMALIES`, and `AI.GENERATE`.
## Reference Directory
- **Functions Reference**:
- **AI.AGG**: [ai_agg.md](references/ai_agg.md) - Multi-row semantic
aggregation and summarization.
- **AI.CLASSIFY**: [ai_classify.md](references/ai_classify.md) - Classify
text.
- **AI.DETECT_ANOMALIES**:
[ai_detect_anomalies.md](references/ai_detect_anomalies.md) - Detect
anomalies.
- **AI.EVALUATE**: [ai_evaluate.md](references