← All updates Databricks Update One-Pager Navy version
databricks Platform · Updated May 20, 2026

Fixed LOD expression syntax update for metric views

Fixed level of detail (LOD) expressions in metric views are now defined directly in the expr field of a dimension using SQL window functions, replacing the previous two step approach of pre…

What it does

Fixed level of detail (LOD) expressions in metric views are now defined directly in the expr field of a dimension using SQL window functions, replacing the previous two step approach of pre computing values in the source query. Level of detail (LOD) expressions let you specify the granularity at which to calculate aggregations, independently of the fields (also called dimensions) in your query. This lets you compute metrics like percent of total, where the denominator aggregates at a coarser grain than the query.

Why it matters

Reduces operational overhead and unlocks new capabilities for data teams on Databricks.

Key capabilities
name: expr: () OVER
name: expr: () OVER (PARTITION BY , , ...)
name: orderpriority expr: oorderpriority
name: orderpriority expr: oorderpriority
name: orderdate expr: oorderdate
name: orderdate expr: oorderdate
name: prioritytotalprice expr: SUM(ototalprice) OVER
name: prioritytotalprice expr: SUM(ototalprice) OVER (PARTITION BY oorderpriority)
Architecture
Databricks Platform → Platform
In short

Fixed level of detail (LOD) expressions in metric views are now defined directly in the expr field of a dimension using SQL window functions, replacing the previous two step approach of pre computing values in the source query. Level of detail (LOD)…

Read the full documentation ↗
Key takeaway
Fixed level of detail (LOD) expressions in metric views are now defined directly in the expr field of a dimension using SQL window functions, replacing the previous two step approach of pre…
2026-05-20-fixed-lod-expression-syntax-update-for-metric-views Generated by the Databricks Updates Agent · browse all updates