--- title: BigQuery measures GA: Unifying BI metrics and knowledge... description: BigQuery measures, previewed earlier this year, is now generally available. It unifies BI metric definitions and knowledge graph relationships in a single... canonical: https://daily.dev/posts/bigquery-measures-ga-unifying-bi-metrics-and-knowledge-graphs-cf9q5uelv twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: BigQuery measures GA: Unifying BI metrics and knowledge graphs | daily.dev og:description: BigQuery measures, previewed earlier this year, is now generally available. It unifies BI metric definitions and knowledge graph relationships in a single... og:url: https://daily.dev/posts/bigquery-measures-ga-unifying-bi-metrics-and-knowledge-graphs-cf9q5uelv og:image: https://api.daily.dev/og/posts/CF9Q5Uelv.png og:image:alt: BigQuery measures GA: Unifying BI metrics and knowledge graphs og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # BigQuery measures GA: Unifying BI metrics and knowledge graphs **[Google Cloud](https://daily.dev/sources/gcp)** · 10 min read · 0 upvotes · 0 comments ## Summary BigQuery measures, previewed earlier this year, is now generally available. It unifies BI metric definitions and knowledge graph relationships in a single schema so dashboards, SQL, GQL queries, and AI agents work from the same governed logic. Measures are defined directly on graph entities via the MEASURE() function and preserve native grain, so joining tables no longer duplicates or overcounts rows. GA adds composite and derived measures, a start_node argument in GRAPH_EXPAND to query multiple fact tables without a 'chasm trap', semantic metadata via an OPTIONS clause, and integration with Knowledge Catalog and Conversational Analytics for discovery by humans and AI agents. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I avoid the chasm trap when joining multiple fact tables in BigQuery Graph? Use the start_node argument in GRAPH_EXPAND to isolate each fact table into its own expansion tree before joining. BigQuery evaluates each measure at its native grain, for example expanding from 'Trans' and 'Card' separately, then joins results on the shared account entity, preventing cross-fact multiplication from inflating metrics like settled_volume and total_cards_issued. _Teams wiring up multi-table analytics track BigQuery's evolving graph features through daily.dev._ ### What does MEASURE() do in a BigQuery property graph definition? MEASURE() defines a grain-locked aggregate, such as SUM(amount) or COUNT(account_id), directly as a property on a node or edge table in a BigQuery property graph. In the generally available version, MEASURE() also supports composite expressions and derived measures built from other measures using AGG(), with circular references validated at schema compilation time. _Developers deciding how to model governed metrics can follow BigQuery graph updates on daily.dev._ ### How can AI agents discover what a BigQuery measure actually calculates? Measures can carry semantic metadata, including description strings, domain synonyms, and custom key-value extensions, set through an OPTIONS clause on the MEASURE() definition. This metadata is automatically ingested into Knowledge Catalog, where agents and analysts can search by synonym and inspect the underlying SQL, such as SUM(CASE WHEN is_settled = TRUE...), before using a metric. _Anyone building agentic analytics pipelines can keep up with semantic layer tooling via daily.dev._ ## Similar posts on daily.dev - [BigQuery Graphs with measures for trusted agentic workloads](https://daily.dev/posts/bigquery-graphs-with-measures-for-trusted-agentic-workloads-hhlpjiley) · Google Cloud · 1 upvotes · 0 comments - [BigQuery Graph: Connecting Data and AI at Scale](https://daily.dev/posts/bigquery-graph-connecting-data-and-ai-at-scale-aqyccgg0s) · Google Cloud · 2 upvotes · 0 comments - [Introducing BigQuery Graph](https://daily.dev/posts/introducing-bigquery-graph-tig40l393) · Google Cloud · 0 upvotes · 0 comments - [Google BigQuery gets managed AI functions to simplify unstructured data analysis](https://daily.dev/posts/google-bigquery-gets-managed-ai-functions-to-simplify-unstructured-data-analysis-jhmzgvsac) · InfoWorld · 0 upvotes · 0 comments --- Tags: [#sql](https://daily.dev/tags/sql), [#gcp](https://daily.dev/tags/gcp), [#data-analysis](https://daily.dev/tags/data-analysis), [#google-bigquery](https://daily.dev/tags/google-bigquery) [View this post on daily.dev](https://daily.dev/posts/bigquery-measures-ga-unifying-bi-metrics-and-knowledge-graphs-cf9q5uelv) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"BigQuery measures GA: Unifying BI metrics and knowledge graphs","url":"https://daily.dev/posts/bigquery-measures-ga-unifying-bi-metrics-and-knowledge-graphs-cf9q5uelv","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/bigquery-measures-ga-unifying-bi-metrics-and-knowledge-graphs-cf9q5uelv"},"datePublished":"2026-10-28T16:11:49.642Z","dateModified":"2026-10-28T16:34:31.601Z","description":"BigQuery measures, previewed earlier this year, is now generally available. It unifies BI metric definitions and knowledge graph relationships in a single...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/9df795f90d3290a29c3b5ccad1c3e312?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/9df795f90d3290a29c3b5ccad1c3e312?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Google Cloud","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Google Cloud","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/gcp","url":"https://daily.dev/sources/gcp"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/bigquery-measures-ga-unifying-bi-metrics-and-knowledge-graphs-cf9q5uelv","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"sql,gcp,data-analysis,google-bigquery","timeRequired":"PT10M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Google Cloud","item":"https://daily.dev/sources/gcp"},{"@type":"ListItem","position":3,"name":"BigQuery measures GA: Unifying BI metrics and knowledge graphs"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/bigquery-measures-ga-unifying-bi-metrics-and-knowledge-graphs-cf9q5uelv#faq","mainEntity":[{"@type":"Question","name":"How do I avoid the chasm trap when joining multiple fact tables in BigQuery Graph?","acceptedAnswer":{"@type":"Answer","text":"Use the start_node argument in GRAPH_EXPAND to isolate each fact table into its own expansion tree before joining. BigQuery evaluates each measure at its native grain, for example expanding from 'Trans' and 'Card' separately, then joins results on the shared account entity, preventing cross-fact multiplication from inflating metrics like settled_volume and total_cards_issued. Teams wiring up multi-table analytics track BigQuery's evolving graph features through daily.dev."}},{"@type":"Question","name":"What does MEASURE() do in a BigQuery property graph definition?","acceptedAnswer":{"@type":"Answer","text":"MEASURE() defines a grain-locked aggregate, such as SUM(amount) or COUNT(account_id), directly as a property on a node or edge table in a BigQuery property graph. In the generally available version, MEASURE() also supports composite expressions and derived measures built from other measures using AGG(), with circular references validated at schema compilation time. Developers deciding how to model governed metrics can follow BigQuery graph updates on daily.dev."}},{"@type":"Question","name":"How can AI agents discover what a BigQuery measure actually calculates?","acceptedAnswer":{"@type":"Answer","text":"Measures can carry semantic metadata, including description strings, domain synonyms, and custom key-value extensions, set through an OPTIONS clause on the MEASURE() definition. This metadata is automatically ingested into Knowledge Catalog, where agents and analysts can search by synonym and inspect the underlying SQL, such as SUM(CASE WHEN is_settled = TRUE...), before using a metric. Anyone building agentic analytics pipelines can keep up with semantic layer tooling via daily.dev."}}]} ```