BigQuery graph measures generally available, GRAPH_EXPAND supports multiple fact tables

You can use graph measures to lock an aggregation to a key in order to perform complex aggregations without overcounting. Measure expressions can include the following:

• Aggregate function calls
• Expressions within aggregate functions
• Conditional logic within aggregate functions
• Conditional distinct counting
• Scalar operations and expressions outside of aggregate functions
• Combinations of measures wrapped in the AGG function

To query measures, you transform your graph into a flattened table by using the GRAPH_EXPAND TVF, and then query measures in that table with the AGG function. The GRAPH_EXPAND function now supports multiple fact tables. To view the output schema of the GRAPH_EXPAND function, use the BQ.SHOW_GRAPH_EXPAND_SCHEMA system procedure.

You can define extensions in the OPTIONS clause of the labels and properties in your graphs, which are string pairs that represent custom metadata for natural language querying.

Measures and graphs are supported in Data Studio through the BigQuery connector. Measures and graphs are also automatically cataloged in Knowledge Catalog, which makes them searchable by natural language or domain synonyms.

These features are generally available (GA).

BigQuery generative AI functions now support the gemini-4-carbon model. This model is generally available.