Build your metrics

Use MetricFlow in dbt to centrally define your metrics. As a key component of the Semantic Layer, MetricFlow is responsible for SQL query construction and defining specifications for dbt semantic models and metrics. It uses familiar constructs like semantic models and metrics to avoid duplicative coding, optimize your development workflow, ensure data governance for company metrics, and guarantee consistency for data consumers.

For a complete list of configuration options and property specs, see the Semantic Layer reference.

This diagram shows how the dbt Semantic Layer works with your data stack.

MetricFlow allows you to:

• Intuitively define metrics in your dbt project
• Develop from your preferred environment, whether that's the dbt platform CLI, Studio IDE, or dbt Core
• Use MetricFlow commands to query and test those metrics in your development environment
• Harness the true magic of the universal Semantic Layer and dynamically query these metrics in downstream tools (Available for dbt Starter, Enterprise, or Enterprise+ accounts only).

Semantic Layer reference

Complete, exhaustive configuration reference for semantic models, metrics, and dimensions.

Migrate to the latest YAML spec

Learn how to migrate from the legacy metrics YAML spec to the latest metrics YAML spec.

Quickstart for the dbt Semantic Layer

Use this guide to build and define metrics, set up the dbt Semantic Layer, and query them using downstream tools.

About MetricFlow

Understand MetricFlow's core concepts, how to use joins, how to save commonly used queries, and what commands are available.

Semantic model

Use semantic models as the basis for defining data. They act as nodes in the semantic graph, with entities connecting them.

Metrics

Define metrics in your dbt project using different metric types in YAML files.

Advanced topics

Learn about advanced topics for dbt Semantic Layer and MetricFlow, such as data modeling workflows, and more.

About the dbt Semantic Layer

Introducing the dbt Semantic Layer, the universal process that allows data teams to centrally define and query metrics

Available integrations

Discover the diverse range of partners that seamlessly integrate with the powerful dbt Semantic Layer, allowing you to query and unlock valuable insights from your data ecosystem.

Related docs

• Quickstart guide with the Semantic Layer
• The Semantic Layer: what's next blog
• Semantic Layer on-demand course
• Semantic Layer FAQs

Was this page helpful?

Privacy policyCreate a GitHub issue

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.