BigQuery AI.AGG: Semantic Aggregation at Scale
🧭 BigQuery introduces AI.AGG, a preview multi-level semantic aggregation function that enables natural-language instructions over millions of rows using a single SQL query. The engine orchestrates row validation, context-safe batching, parallel inference with Vertex AI, and recursive synthesis to produce final group-level summaries. AI.AGG supports text and multimodal inputs, integrates with BigQuery Object Tables, and requires careful prompting and NULL handling for reliable production use.
