| name | bigquery-ai-ml |
| metadata | {"category":"AiAndMachineLearning"} |
| description | 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. |
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: Leveraging pre-trained
TimesFM model for forecasting without custom training.
-
AI Detect Anomalies: Identify
deviations in time series data using pre-trained TimesFM model.
-
AI Generate: General-purpose text and
content generation using Gemini models.
-
AI Key Drivers: Automatically identify
dimensional segments most responsible for driving changes in a metric.
Related Skills
- BigQuery Basics Skill:
SKILL.md file for core BigQuery concepts, resource management, CLI,
and client libraries.
