About MetricFlow
MetricFlow is a semantic layer that makes it simpler to define and manage metrics in code. It compiles those metric definitions into clear, reusable SQL, so results stay consistent and accurate when analyzed by relevant attributes, or dimensions. It is maintained by dbt Labs, written in Python, and released under the Apache-2.0 license.
The name reflects its method: a request for a metric is compiled into a dataflow-based query plan that is optimized and translated into engine-specific SQL. It helps with complicated logic such as multi-hop joins between fact and dimension sources and complex metric types, generating queries dynamically instead of requiring hand-written SQL for every cut of the data.
Documentation is hosted in the dbt docs, and a changelog tracks updates. MetricFlow suits analytics engineers and data teams who want a single source of truth for business metrics that can feed dashboards, notebooks, and other tools.
Key features
- Metric definitions managed as code
- Compiles metrics to engine-specific SQL
- Dataflow-based query planning
- Multi-hop joins across fact and dimension sources
- Support for complex metric types
- Consistent dimensions across queries
Good fit for
- A governed metrics layer for BI tools
- Consistent KPIs across dashboards and notebooks
MetricFlow: questions and answers
- What is MetricFlow used for?
- MetricFlow is a semantic layer from dbt Labs that defines metrics in code and compiles requests into optimized, reusable SQL with consistent dimensions and joins. It is a good fit for a governed metrics layer for BI tools, and consistent KPIs across dashboards and notebooks.
- Is MetricFlow open source?
- Yes. MetricFlow is open source under the Apache-2.0 licence. Its source code is on GitHub at dbt-labs/metricflow and is written mainly in Python.
- Is MetricFlow free?
- Yes. MetricFlow is open source, so the software itself is free to use.
- What is MetricFlow an alternative to?
- MetricFlow is an open-source alternative to Looker and AtScale. Other open-source alternatives to Looker include Superset, Cube and Redash.
- Is MetricFlow actively maintained?
- Yes. The most recent commit to MetricFlow was on 2 November 2026, and the latest release is v0.213.0, published on 10 September 2026. The project has 1.9k stars on GitHub, with 46 added in the last 30 days.
Open-source alternatives to MetricFlow
See all
Superset
BI & Dashboards
Apache Superset is a Data Visualization and Data Exploration Platform
Apache-2.0vs Tableau★ 75k
Cube
BI & Dashboards
📊 Cube Core is open-source semantic layer for AI, BI and embedded analytics
OSSvs Looker★ 21k
Redash
BI & Dashboards
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and
BSD-2-Clausevs Data Studio★ 29k
Metabase
BI & Dashboards
The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets ev
OSSvs Tableau★ 50k
Saiku
BI & Dashboards
Open-source semantic layer: one cube for Excel (MDX/XMLA), dashboards, and AI agents (MCP)
Apache-2.0vs Tableau★ 1.3k
dbt
Data Pipelines & ETL
dbt enables data analysts and engineers to transform their data using the same practices t
Apache-2.0vs Matillion★ 14k
SaaS alternatives to MetricFlow
See all
Looker
BI & Dashboards
Google Cloud business intelligence platform with a governed semantic modeling layer
SaaS
AtScale
BI & Dashboards
Semantic layer platform that provides governed metrics to BI tools
SaaS
Pentaho
Data Pipelines & ETL
Data integration and analytics platform from Hitachi Vantara
SaaSDenodo
Data Pipelines & ETL
Data virtualization and logical data management platform
SaaS
Microsoft Fabric
Data Pipelines & ETL
Unified analytics platform combining data engineering, warehousing and Power BI
SaaS
Supermetrics
Data Pipelines & ETL
Connectors that move marketing data into spreadsheets, BI tools and warehouses
SaaS

