BigQuery Graph measures explained (Why your AI agents get metrics wrong and how measures fix it)

Learn more about measures here. → https://g.dev/ai/bq-measure

In this BigQuery tutorial, you’ll learn how to define graph measures with MEASURE, query them with AGG, and reuse calculations across different groupings. Follow a simple music dataset to fix double counting and explore the relationships behind the results.

Chapters:

00:00 - Why AI can return the wrong numbers

00:36 - The music dataset and our question

01:50 - How SQL joins cause double counting

03:22 - How BigQuery Graph measures work

04:40 - Define a measure with MEASURE

05:08 - SUM vs. AGG: Getting the correct total

06:12 - Explore the relationships behind the numbers

07:24 - Recap and how to get started

More resources:
BigQuery Graph query overview → https://g.dev/cloud/graph-query-overview
BigQuery Graphs with measures for trusted agentic workloads → https://g.dev/ai/bigquery-graphs-with-measures

Follow Annie online:
LinkedIn → https://goo.gle/annie-linkedin
X → https://goo.gle/annie-x
🔔 Subscribe to Google Cloud Tech → https://goo.gle/GoogleCloudTech

Speaker: Annie Wang
Products Mentioned: BigQuery, Gemini Live API, Agent Development Kit