---
id: gh-bigquery-ai-ml
name: "bigquery-ai-ml"
url: https://skills.yangsir.net/skill/gh-bigquery-ai-ml
author: google
domain: data-ai
tags: ["bigquery", "machine-learning", "generative-ai", "time-series", "forecasting"]
install_count: 7000
rating: 4.50 (120 reviews)
github: https://github.com/google/skills/tree/main/skills/cloud/bigquery-ai-ml
---

# bigquery-ai-ml

> 此技能在 BigQuery 中通过内置函数（如 AI.FORECAST、AI.GENERATE）直接调用 Vertex AI 模型，实现时间序列预测、异常检测、关键驱动因素分析和文本生成。用户无需移动数据或编写复杂代码，即可在 SQL 工作流中快速集成机器学习与生成式 AI，大幅提升数据分析效率。

**Stats**: 7,000 installs · 4.5/5 (120 reviews)

## Before / After 对比

### 时间序列预测耗时对比

**Before**:

用户需要导出数据到外部环境，手动训练或配置机器学习模型，再导回结果。整个过程涉及多个工具切换，通常需要数小时甚至数天。

**After**:

此技能直接在 BigQuery 中使用 AI.FORECAST 函数，在 SQL 查询中完成预测，几分钟内获得结果，无需离开数据仓库。

| Metric | Before | After | Change |
|---|---|---|---|
| 预测耗时 | 120分钟 | 5分钟 | -96% |

## Readme

# 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

-   [AI Forecast](references/ai_forecast.md): Leveraging pre-trained
    TimesFM model for forecasting without custom training.

-   [AI Detect Anomalies](references/ai_detect_anomalies.md): Identify
    deviations in time series data using pre-trained TimesFM model.

-   [AI Generate](references/ai_generate.md): General-purpose text and
    content generation using Gemini models.

-   [AI Key Drivers](references/ai_key_drivers.md): Automatically identify
    dimensional segments most responsible for driving changes in a metric.

## Related Skills

- [BigQuery Basics Skill](../bigquery-basics):
  SKILL.md file for core BigQuery concepts, resource management, CLI,
  and client libraries.


---
*Source: https://skills.yangsir.net/skill/gh-bigquery-ai-ml*
*Markdown mirror: https://skills.yangsir.net/api/skill/gh-bigquery-ai-ml/markdown*