MetricFlow
github.com
- Free plan
- Open source
- Windows
- macOS
- Linux
- Web
- API
- Self-hosted
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.
Plans
Every plan and priceEnterprise
Enterprise+
Developer
MetricFlow
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.