bigquery-ai-ml

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, or leverage generative AI capabilities in BigQuery.
metadata	{"category":"data","source":{"repository":"https://github.com/google/skills","path":"skills/cloud/bigquery-ai-ml","license_path":"LICENSE","commit":"28d90a333c4d900bcc76e498363e0c835dc69a5c"}}

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.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.

Related Skills

• BigQuery Basics Skill: SKILL.md file for core BigQuery concepts, resource management, CLI, and client libraries.