All skills
bigquery-ai-ml
Write BigQuery SQL that forecasts time series, detects anomalies, classifies text, and runs GenAI functions.
- Part of google/skills
- 8.5k installs
- Data · Analytics
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.
More Analytics skills
See all- fabric-lakehouse8.8kExplains Microsoft Fabric Lakehouse components and best practices for designing and optimizing lakehouse solutions.
- accelerated-computing-cudf3.2kGuides GPU DataFrame work with cuDF, including pandas acceleration, joins, groupby, file I/O and multi-GPU jobs.
- polars2.3kRuns fast, memory-efficient data processing and analytics on DataFrames in Python.
- polars-bio2.1kPerforms genomic interval operations and reads or writes common bioinformatics file formats.
Also in this pack
- cloud-run-basics19.4kDeploys and manages Cloud Run services, jobs and worker pools.
- gemini-api18.8kWrites code that calls Gemini models for text, images, video, audio, embeddings and more across languages.
- google-cloud-recipe-auth17.1kExplains how to authenticate and authorize users and services to Google Cloud APIs, including IAM and ADC.
- google-cloud-recipe-onboarding16.9kWalks a new developer through creating a Google Cloud account, setting up billing and deploying a first resource.