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.KEYDRIVERS, AI.DETECTANOMALIES, and AI.GENERATE.
[!IMPORTANT]
You MUST read and follow the global constraints and mandatory function routing rules in
[aifunctionbestpractices.md](references/aifunctionbestpractices.md) before writing any BQML AI/ML SQL query.
Reference Directory
- Best Practices:
[aifunctionbestpractices.md](references/aifunctionbestpractices.md)
- Functions Reference:
- AI.AGG: [aiagg.md](references/aiagg.md) - Multi-row semantic aggregation and summarization. - AI.CLASSIFY: [aiclassify.md](references/aiclassify.md) - Classify text. - AI.DETECTANOMALIES: [aidetectanomalies.md](references/aidetectanomalies.md) - Detect anomalies. - AI.EVALUATE: [aievaluate.md](references/aievaluate.md) - Evaluate models. - AI.FORECAST: [aiforecast.md](references/aiforecast.md) - Time-series forecasting. - AI.GENERATE: [aigenerate.md](references/aigenerate.md) - Generate text using LLMs. - AI.GENERATEEMBEDDING: [aigenerateembedding.md](references/aigenerateembedding.md) - Generate embeddings. - AI.GENERATETABLE: [aigeneratetable.md](references/aigeneratetable.md) - Table-valued AI generation. - AI.IF: [aiif.md](references/aiif.md) - Evaluate semantic conditions. - AI.KEYDRIVERS: [aikeydrivers.md](references/aikeydrivers.md) - Identifies key drivers, this is a TVF. - AI.SCORE: [aiscore.md](references/aiscore.md) - Score data. - AI.SEARCH: [aisearch.md](references/aisearch.md) - Semantic search. - AI.SIMILARITY: [aisimilarity.md](references/aisimilarity.md) - Semantic similarity. - Remote Models: [remotemodels.md](references/remotemodels.md) - Working with remote models (Vertex AI). - CONTRIBUTIONANALYSIS: [mlcontributionanalysis.md](references/mlcontributionanalysis.md) - Finds contributing factors, key drivers of change. Requires creating a MODEL entity. - VECTORSEARCH: [vectorsearch.md](references/vectorsearch.md) - Vector search best practices.