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
-
Functions Reference:
- AI.AGG: ai_agg.md [blocked] - Multi-row semantic aggregation and summarization.
- AI.CAUSAL_EFFECT: ai_causal_effect.md [blocked] - Quantifies the impact of an intervention on a time series.
- AI.CLASSIFY: ai_classify.md [blocked] - Classify text.
- AI.DETECT_ANOMALIES: ai_detect_anomalies.md [blocked] - Detect anomalies.
- AI.EVALUATE: ai_evaluate.md [blocked] - Evaluate models.
- AI.FORECAST: ai_forecast.md [blocked] - Time-series forecasting.
- AI.GENERATE: ai_generate.md [blocked] - Generate text using LLMs.
- AI.GENERATE_EMBEDDING: ai_generate_embedding.md [blocked] - Generate embeddings.
- AI.GENERATE_TABLE: ai_generate_table.md [blocked] - Table-valued AI generation.
- AI.IF: ai_if.md [blocked] - Evaluate semantic conditions.
- AI.KEY_DRIVERS: ai_key_drivers.md [blocked] - Identifies key drivers, this is a TVF.
- AI.SCORE: ai_score.md [blocked] - Score data.
- AI.SEARCH: ai_search.md [blocked] - Semantic search.
- AI.SIMILARITY: ai_similarity.md [blocked] - Semantic similarity.
- Remote Models: remote_models.md [blocked] - Working with remote models (Vertex AI).
- CONTRIBUTION_ANALYSIS:
ml_contribution_analysis.md [blocked]
- Finds contributing factors, key drivers of change. Requires creating a MODEL entity.
- ML.CORRELATION: ml_correlation.md [blocked] - Calculates correlation between columns, optionally sliced by dimensions.
- ML.DETECT_CHANGE_POINTS: ml_detect_change_points.md [blocked] - Detects structural breaks or sustained shifts in a time series.
- ML.SEASONALITY: ml_seasonality.md [blocked] - Extracts seasonal components from a time series.
- ML.TREND: ml_trend.md [blocked] - Extracts the long-term trend component from a time series.
- VECTOR_SEARCH: vector_search.md [blocked] - Vector search best practices.
Related Skills
- BigQuery Basics Skill: SKILL.md file for core BigQuery concepts, resource management, CLI, and client libraries.