# Bigquery AI Ml

> Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

- Skill: `google/bigquery-ai-ml` (Agent Skill, multi-file: 5 files)
- Install (CLI): `npx skillmds@latest add google/bigquery-ai-ml`
- Raw SKILL.md: https://api.skillmd.com/api/skills/google/bigquery-ai-ml/raw
- Safety review: PASS (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics, AI & ML, DevOps & Infra, Data Analysis, SQL & Databases
- Tags: Anomaly Detection, Bigquery, Forecasting, Gemini, Key Driver Analysis, Text Generation, Timesfm, Vertex Ai
- Author: Google (https://skillmd.com/u/google), verified publisher
- Updated: 2026-07-06
- Page: https://skillmd.com/skills/google/bigquery-ai-ml

---


# 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.