Build and maintain all of your metric logic in code.
Welcome to MetricFlow
See our latest updates in the Metricflow Changelog!
MetricFlow is a semantic layer that simplifies defining and managing metrics. It compiles these metric definitions into clear, reusable SQL, ensuring consistent and accurate results when analyzing data by relevant attributes (dimensions).
The name “MetricFlow” reflects its approach: metric requests are compiled into a dataflow-based query plan, which is then optimized and translated into engine-specific SQL.
MetricFlow provides a set of abstractions that help you construct complicated logic and dynamically generate queries to handle:
- Multi-hop joins between fact and dimension sources
- Complex metric types such as ratio, expression, and cumulative
- Metric aggregation to different time granularities
- And so much more
To get up and running with your own metrics, you should rely on MetricFlow’s documentation.
Licensing
MetricFlow is distributed under the Apache 2.0 license. For details, please refer to our licensing agreement.
Open Semantic Interchange (OSI) Initiative
MetricFlow is developed and maintained as part of the Open Semantic Interchange (OSI) initiative. The OSI initiative is a collaborative effort among leading technology companies and data practitioners to establish a open standard for defining and exchanging semantic information, enabling AI/BI interoperability across different platforms and tools.
Getting Started
Install MetricFlow
MetricFlow can be installed from PyPi for use as a Python library with the following command:
pip install dbt-metricflow
MetricFlow currently serves as a query compilation and SQL rendering library, built to work in conjunction with a dbt project. As such, using MetricFlow requires a working dbt project and a dbt adapter. We provide the dbt-metricflow bundle for this purpose. You may choose to install other adapters as optional extras from dbt-metricflow.
You may need to install Postgres or Graphviz. You can do so by following the install instructions for Postgres or Graphviz. Mac users may prefer to use brew: brew install postgresql or brew install graphviz.
Tutorial
The best way to get started is to follow the tutorial steps, which you can access by running:
mf tutorial
Note: this must be run from a dbt project root directory.
Resources
Contributing and Code of Conduct
This project will be a place where people can easily contribute high-quality updates in a supportive environment.
Please read our code of conduct before diving in.
To get started on direct contributions, head on over to our contributor guide.
License History
MetricFlow is source-available software.
Version 0 to 0.140.0 was covered by the Affero GPL license. Version 0.150.0 to 0.208.2 was covered by the BSL license. Version 0.209.0 and greater is covered by the Apache 2.0 license.
MetricFlow is built by dbt Labs.
2 maintainers
Release files for metricflow 0.213.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| metricflow-0.213.0.tar.gz | 643.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| metricflow-0.213.0-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 1.6 MB
Release files / metricflow-0.213.0.tar.gz
| Download URL | metricflow-0.213.0.tar.gz |
|---|---|
| Size | 643.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
e6b5e8f05a0b9b0183430416052a61747fc89f809c39f2cdc5a3d9ba7a3f6931
|
|
BLAKE2b-256 checksum How to use checksums |
a6ae0c75d87f004cd56f30862fa1330f6a4e36a26ea32463a6d17d5d1ab32413
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency logRelease files / metricflow-0.213.0-py3-none-any.whl
| Download URL | metricflow-0.213.0-py3-none-any.whl |
|---|---|
| Size | 999.5 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
6e1865535a200607529970f6ca1a9fcd22b7814d0b71cd654d9ee01eecf0157b
|
|
BLAKE2b-256 checksum How to use checksums |
586c2ec7e3c433bdab3cf15f4424769794f6d0dab9ecd3c43da00cdb85435d44
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 10, 2026.
Transparency log
