Bigquery AI ML
Developmentbigquery-ai-mlBigquery AI ML is an Agent Skill for development published in the google/skills repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
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.
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
Inspect the Agent Skill at https://github.com/google/skills/blob/HEAD/skills/cloud/bigquery-ai-ml/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/bigquery-ai-ml, but wait for my approval before writing files or running scripts.
Copying this prompt does not install or run the skill. Review third-party files before use.
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.