BigQuery's AI.AGG Function for Data Synthesis

BigQuery introduced the AI.AGG() function in preview, letting users summarize or synthesize information over millions of rows of unstructured or multimodal data using natural-language instructions. Use cases include log analysis and product categorization from text and images, with best practices for context windows and NULL handling.