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

Author: Google Cloud Tech - Bewertung: 12x - Views:110

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