Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

MetricFlow

github.com

  • Free plan
  • Open source
  • Windows
  • macOS
  • Linux
  • Web
  • API
  • Self-hosted
8.5 Club score Visit github.com

What MetricFlow is

MetricFlow defines metric logic and generates SQL for querying metrics across data dimensions. Developed and maintained by dbt Labs, it lets teams describe metrics and semantic models in YAML files within a dbt project. Supported metric types include simple, conversion, cumulative, derived, and ratio metrics. Entity types and parameters guide how it constructs joins, helping avoid fan-out and chasm joins. MetricFlow works with dbt 1.6 and later, and lists Snowflake, BigQuery, Databricks, Redshift, and Postgres for dbt v1 only as supported data platforms. A working dbt project and adapter are required. The tool is self-hosted, free, and licensed under Apache 2.0; installation is available from PyPI with `pip install dbt-metricflow`. It does not currently support dbt built-in functions or packages. Custom integrations can use JDBC, ADBC, GraphQL, or the Python SDK. The dbt Semantic Layer, powered by MetricFlow, lists integrations including Power BI, Tableau, Google Sheets, Excel, Omni, Hex, Mode, and Sigma. Hosted access to that layer is listed for dbt Starter, Enterprise, and Enterprise+ plans; Starter is $100 per user/month.

Who it suits

MetricFlow suits teams with a working dbt project and adapter that want to define reusable metrics and query them across dimensions. It may also suit developers building custom integrations through its listed APIs or Python SDK.

Good to know, and what to watch

  • Defines metrics and semantic models in YAML.
  • Supports five listed metric types.
  • Uses entity types and parameters to construct joins.
  • Offers JDBC, ADBC, GraphQL, and Python SDK integrations.
  • Free and licensed under Apache 2.0.
  • Requires a working dbt project and adapter.
  • Does not support dbt built-in functions or packages.
  • Postgres is listed for dbt v1 only.
  • Hosted Semantic Layer Starter is $100 per user/month.

Enterprise

—

Enterprise+

—

Developer

Free

MetricFlow

Free

Open source

The verdict

MetricFlow provides a self-hosted way to define metric logic in dbt and generate SQL for it. Check its dbt requirements and function limitations, and distinguish the free tool from paid hosted Semantic Layer access.

What the maker publishes

AI integration
Claude and ChatGPT can connect through the dbt MCP server to query governed metrics. source
API
The hosted Semantic Layer exposes GraphQL and JDBC interfaces for metric queries. source
APIs
Custom integrations can use JDBC, ADBC, GraphQL, and the Python SDK library. source
CLI capabilities
Commands can list metrics, dimensions, dimension values, entities, and saved queries, query metrics, validate configurations, and run exports. source
Configuration
Metrics and semantic models are authored in YAML, with Ossie documents supported as an alternative from dbt 1.12. source
dbt compatibility
MetricFlow is compatible with dbt version 1.6 and higher. source
Definitions
Metrics and semantic models can be defined in YAML files in a dbt project. source
Documentation depth
The developer documentation includes guides for joins, time spines, validations, semantic models, metrics, saved queries, advanced modeling, deployment, caching, exports, integrations, and APIs. source
Founded
2016 source
Headquarters
Oakland, California, USA source
Hosted access
The dbt Semantic Layer is listed for dbt Starter, Enterprise, and Enterprise+ plans; the pricing page lists Starter at $100 per user/month. source
Hosted execution
On dbt Platform, MetricFlow commands run remotely through dbt sl and platform-managed versions. source
Installation
Self-hosted installation uses pip with the dbt-metricflow package and optional adapter extras. source
Integrations
The dbt Semantic Layer, powered by MetricFlow, lists Power BI, Tableau, Google Sheets, Excel, Omni, Hex, Mode, Sigma, and other integrations. source
Integrations
Official documentation lists downstream integrations including Tableau, Hex, Dot, Mode, and Google Sheets. source
Joins
MetricFlow uses entity types and parameters to construct joins and avoid fan-out and chasm joins. source
Licence
MetricFlow versions 0.209.0 and newer use Apache 2.0; earlier releases used AGPL or BSL licensing. source
License and installation
MetricFlow is distributed under Apache 2.0 and can be installed from PyPI with `pip install dbt-metricflow`. source
Limit: hosted dependency
The independent review states that the managed semantic service and API require dbt Cloud; dbt Core can define metrics locally but lacks the hosted registry and API. source
Limit: modeling effort
The independent review says teams must ensure correct keys and grains and that upfront semantic modeling is a tradeoff. source
Limit: performance
The independent review warns that large windowed calculations can be expensive and still require warehouse partitioning, rollups, or pre-aggregation. source
Maker
MetricFlow is developed and maintained by dbt Labs. source
Maker founded
Crunchbase says dbt Labs was founded in 2016. source
Maker headquarters
Crunchbase lists Philadelphia, Pennsylvania as dbt Labs' headquarters. source

Checked against the maker's pages on 15 Oct 2026.