Gemini Omni 1.2 Flash: Fast and cost-effective with longer clips
deepmind.google·8h ago
Cloud & Infrastructure
Google Cloud Blog·8h ago·5 min read
Semantic aggregation over millions of rows in BigQuery with AI.AGG
TL;DR
AI.AGG is a new semantic aggregation function in BigQuery that allows users to analyze millions of rows of unstructured data with a single SQL query. This innovation simplifies the process of extracting insights from complex datasets, bridging a critical gap in data analysis capabilities.
✦ Why It Matters
Start using AI.AGG in BigQuery to simplify your unstructured data analysis today.
Key Takeaways
- Utilize AI.AGG for efficient analysis of unstructured data.
- Implement context-safe batching to avoid data truncation.
- Use explicit output contracts in prompts for better results.
- Leverage multimodal capabilities for comprehensive insights.
How It Works
AI.AGG simplifies the aggregation process by automatically validating row sizes, batching inputs to fit within LLM token limits, and executing parallel inference. It recursively synthesizes intermediate outputs until a final summary is produced, allowing for holistic analysis of large datasets.