Find your next open-source project

Search by name, purpose, or keyword — or paste a GitHub repository URL
All skills

bigquery-ai-ml

Write BigQuery SQL that forecasts time series, detects anomalies, classifies text, and runs GenAI functions.

When to use it

You already have BigQuery tables of time-series or text data and need a SQL query that forecasts, scores, or classifies them.

For example

You say

Use the bigquery-ai-ml skill to write a query that forecasts daily sales in my `sales.daily` table for the next 30 days.

You get
  • AI.FORECAST SQL query
  • Forecast output columns

How it works

  • Picks the right function for each task, such as AI.FORECAST versus ML.DETECT_CHANGE_POINTS for shifts versus point anomalies.
  • Covers statistical helpers like ML.CORRELATION, ML.DESCRIBE_DATA, ML.TREND, and ML.SEASONALITY.

Before installing

Functions like AI.GENERATE_TABLE, AI.GENERATE_EMBEDDING, and VECTOR_SEARCH need a Vertex AI remote model created with CREATE MODEL.