Bigquery AI Ml

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

Google Updated 14.4k repo stars

File contents

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.

google/skills/tree/main/skills/cloud/bigquery-ai-ml commit aabe37a010

Frequently asked questions

npx skillmds@latest add google/bigquery-ai-ml