Summarize millions of rows with one line of SQL: AI.AGG @googlecloudtech
Summarize millions of rows with one line of SQL: AI.AGG  @googlecloudtech
Uploaded May 2026 | Updated September 2026, 2 weeks ago
Documentation for the AI.AGG function → https://goo.gle/bq-ai-agg
Generative AI in BigQuery overview → https://goo.gle/bq-genai-overview

Apply the reasoning capabilities of Gemini to your BigQuery data at scale with the new AI.AGG function. While standard AI functions work row by row, AI.AGG empowers you to step back and analyze the "big picture" by reasoning over entire groups of data using just SQL.

In this video, Thomas demonstrates how to use natural language instructions to summarize themes, identify sentiment trends, and analyze multimodal data (text and images) with a single line of SQL.

Chapters:
0:00 - Introduction to AI.AGG
0:16 - Why use AI aggregation?
0:57 - How AI.AGG works
1:18 - Demo: Summarizing text reviews
2:01 - Demo: Multimodal reasoning (text + images)
2:28 - Conclusion & next steps

🔔 Subscribe to Google Cloud Tech → https://goo.gle/GoogleCloudTech

#BigQuery #GoogleCloud

Speaker: Thomas Anchor
Products Mentioned: BigQuery, Gemini
Summarize millions of rows with one line of SQL: AI.AGGDeploying a GPU powered LLM on Cloud RunAI agent long-term memory with memory bankThis AI agent is raising millions for startups | The Agent FactoryScale AI agents in productionAI travel planner, powered by Spanner (Multi-model)How to use generative AI to make data science betterStop rogue AI: Enforce policy & cut costs in Agent Development Kit (ADK)Converting SQL Server code to PostgreSQLWhats new in Google Cloud databases for the agentic eraMeet Cloud SQL: Google Clouds fully managed and intelligent relational database serviceBreaking silos with agentic AI: How Google Cloud transforms enterprise data into real-time action
Google Cloud Tech |

Summarize millions of rows with one line of SQL: AI.AGG

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER