A Unity Catalog object whose YAML definition (WITH METRICS LANGUAGE YAML) sets out measures and dimensions over a source in one place. Ordinary SQL reads it through MEASURE().
Read more: Databricks docs
In the Ultra Transcenders books
Each book explains Metric view in context, with comparison tables and the common traps.
Terms in this definition
- Unity Catalog
Azure Databricks' governance solution covering both data and AI in one place, with centralised permissions, auditing, data discovery and lineage.
- YAML
A data format designed to be easy for people to read, used for Container Apps definitions, ACR multi-step tasks and Kubernetes manifests.
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- Measure
A figure like total revenue, worked out by aggregating fact table data wherever dimensions intersect within a semantic model.
Related terms
- KPI
A figure a business watches against a goal. A metric view holds a single definition of it, which keeps the number consistent across teams.
- MEASURE function
How you ask for a metric view's measure in SQL: for instance,
MEASURE(total_revenue). - Metric view materialization
An optional way to keep a metric view's results ready-computed, held in materialized views that a Lakeflow pipeline maintains. Queries are sent to them automatically by the optimiser, so nobody has to rewrite their SQL.