# bigquery-ai-ml

> Claude/Codex skill by [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md) · 226 stars · Updated 2026-10-23

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, detect outliers, find key drivers, or leverage generative AI capabilities in BigQuery.

## Install

```sh
git clone https://github.com/GoogleCloudPlatform/data-agent-kit-plugin /tmp/data-agent-kit-plugin && ln -s /tmp/data-agent-kit-plugin/skills/bigquery-ai-ml ~/.claude/skills/bigquery-ai-ml
```

## From 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.KEYDRIVERS, AI.DETECTANOMALIES, and AI.GENERATE. \[!IMPORTANT\] You MUST read and follow the global constraints and mandatory function routing rules in aifunctionbestpractices.md before writing any BQML AI/ML SQL query. Reference Directory Best Practices: aifunctionbestpractices.md Functions Reference: AI.AGG: aiagg.md - Multi-row semantic aggregation and summarization. AI.CLASSIFY: aiclassify.md - Classify text. AI.DETECTANOMALIES: aidetectanomalies.md - Detect anomalies. AI.EVALUATE: aievaluate.md - Evaluate models. AI.FORECAST: aiforecast.md - Time-series forecasting. AI.GENERATE: aigenerate.md - Generate text using LLMs. AI.GENERATEEMBEDDING: aigenerateembedding.md - Generate embeddings. AI.GENERATETABLE: aigeneratetable.md - Table-valued AI generation.

## Links

- HTML page: https://omgskills.com/library/googlecloudplatform/data-agent-kit-plugin/skills/bigquery-ai-ml/
- GitHub: https://github.com/GoogleCloudPlatform/data-agent-kit-plugin
- Author: [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md)

## More from this repo

- [accidental-data-loss-prevention](https://omgskills.com/library/googlecloudplatform/data-agent-kit-plugin/skills/accidental-data-loss-prevention/index.md) — \*\*STOP AND VERIFY\*\*: Before running any command or tool that results in irreversible data loss, you MUST obtain...
   - [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md) · 226 stars
- [bigquery-bigframes](https://omgskills.com/library/googlecloudplatform/data-agent-kit-plugin/skills/bigquery-bigframes/index.md) — Generates Python code using BigQuery DataFrames (BigFrames).
   - [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md) · 226 stars
- [bigquery-data-transfer-service](https://omgskills.com/library/googlecloudplatform/data-agent-kit-plugin/skills/bigquery-data-transfer-service/index.md) — Discovers and inspects BigQuery Data Transfer Service (DTS) configurations.
   - [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md) · 226 stars