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.