| name | bigquery-ai-ml |
| 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. |
| version | 1.0.0 |
| author | google |
| license | Apache-2.0 |
| platforms | ["linux","macos","windows"] |
| source | https://github.com/google/skills/tree/main/skills/cloud/bigquery-ai-ml |
| metadata | {"category":"AiAndMachineLearning","hermes":{"icon":"lucide:database","tags":["Google Cloud","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: 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.
