Skip to main content

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.

This diagram shows how the dbt Semantic Layer works with your data stack.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 Cloud CLI, Cloud 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 Cloud Team or Enterprise accounts only).

Quickstart for the dbt Cloud 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 through the powerful combination of measures, constraints, or functions, effortlessly organized in either YAML files or separate 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.

0