bigquery-ai-ml
GitHub利用BigQuery内置的ML和GenAI功能进行高级数据分析。适用于编写执行时间序列预测、异常检测、关键驱动因素分析及生成式AI任务的SQL查询,集成Vertex AI能力。
Trigger Scenarios
Install
npx skills add google/skills --skill bigquery-ai-ml -g -y
SKILL.md
Frontmatter
{
"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.
Version History
- aabe37a Current 2026-07-05 15:28


