Easily convert an out of date dbt metrics spec into the latest suported metrics spec in dbt
Project description
The dbt converter is a CLI tool that simplifies the process of migrating from the metrics spec supported in dbt v1.5 and earlier to the metrics specification supported in dbt ≥v1.6.
Installing dbt converter
pip install dbt-metrics-converter
Upgrading to dbt v1.6 spec
- Navigate to the root of your dbt project.
pip install dbt-metrics-converter
. Note that the converter requires dbt-core==1.5. You may need to update the version range for the dbt_metrics package.- Run
dbtc convert-metrics
. The converter assumes you are in the root of your dbt project. Optionally, you can pass the project path-dbt-project-path path/to/dbt_project
. NOTE: All metrics must have a timestamp for the upgrade to run. If your metrics do not have a timestamp, add one before running the converter. - Semantic models and metrics files will be created in the
semantic_models
andmetrics
directories. Move these folders into your model path. - Delete the
metrics
package, move the old metrics configs out of your model path, or delete them.
Testing your metrics in dbt v1.6
- Upgrade to dbt v1.6, and
pip install dbt-metricflow
- Remove the old metrics package from your
dbt_packages
and rundbt clean && dbt deps
. - Run
dbt parse
to generate a semantic manifest - View the metrics in your dbt project by running
mf list metrics
- Run
mf validate-configs —skip-dw
to validate metrics configs. - To run a test query, run
mf query --metrics <metric_name>
Gotchas:
- Some packages, like fivetran/ad_reporting have metrics defined in them using the v1.5 spec, this may cause an error if you try to run your project after upgrading to v1.6
- Make sure to delete any calls of
metrics.calculate
ormetrics.develop
they won’t work without the dbt_metrics package
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for dbt_metrics_converter-0.1.5.3.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | ca0b5f8578f9d99e60b536252137632c30a6b0f614f0b7a8dbf7fcf088d9aa3f |
|
MD5 | 47f052fe4f289d8c7d03ef68b6ed9b5c |
|
BLAKE2b-256 | 113640ff94e8421a28afa1aa7dfb380f2f6c6766960731b5e197b215aa0906f8 |
Close
Hashes for dbt_metrics_converter-0.1.5.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9d6f60fb82ea2c27bc4a81d217f268d52fd6060f925c5b9c6cce7dc7546233ac |
|
MD5 | acaa0c8dbbf39df245db87f9d8ceedea |
|
BLAKE2b-256 | 1295a3af22fd4ff74a02a707d4f1944e8a2a29de6b78c685471c46e5e6675c94 |