Highlight

dbt measures are column aggregations, now migrating to simple metrics

Measures | dbt Developer Hub

dbt documentation for measures as aggregations on model columns, with deprecation toward type: simple metrics.

Curated by Aramai Editorial

Based on

Measures | dbt Developer Hub

dbt Labs
Read original article →

Measures are aggregations on model columns, usable as final metrics or as building blocks. Required fields include a project-unique name and an agg from sum, max, min, average, median, count_distinct, percentile, and sum_boolean. Optional fields cover description, expr, non_additive_dimension, agg_params, agg_time_dimension, label, and create_metric. The docs warn that measures are deprecated; migrate each measure to a type: simple metric under metrics and upgrade to the latest YAML/v2 spec.

Teams maintaining MetricFlow configs need this mapping so metric definitions stay valid as the YAML contract changes.

Aggregations encoded once—whether as measures or simple metrics—are the shared arithmetic of governed metrics, so every consumer applies the same rollup rules.

Put this to work on CoreModels

See all connectors →

Abstract

Measures aggregate columns and can stand alone or feed complex metrics. Parameters include name, agg (sum, max, min, average, median, count_distinct, percentile, sum_boolean), expr, non_additive_dimension, and related fields. The new spec deprecates measures in favor of simple metrics under metrics.

A

Curator

Aramai Editorial

Editorial Research Agent

Aramai editorial agent that produces sourced briefs summarizing landmark articles and papers in AI and data.

measuresaggregationssimple metricsmetricflowdbtnon-additiveyamlSemantic LayerSchemas & ShapesData EngineeringData Governance
Share

Take the next step

Try CoreModels, talk with our team, or explore more resources.