Google Cloud Tech: 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