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
