Easily convert out of date, or unsported 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 requiresdbt-core==1.5
. You may need to update the version range for thedbt_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.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 841c0bcbd8f83054db14e7de7b238f3bd79ba473393d16c16916e14623b7c282 |
|
MD5 | a4c9d4b6eeaff8d0abf43196de619c19 |
|
BLAKE2b-256 | e84d71090ed99b7b250552ea3dfc0c900c255d1fc08d54adb353558d64dff87e |
Close
Hashes for dbt_metrics_converter-0.1.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 34421c0c8dfcf6082d9351fc128bd939e2380d979be310ceb60752304501ec69 |
|
MD5 | ddcaf237e1f0eac5d00c7df724d5312d |
|
BLAKE2b-256 | d5524029b251396af9afecd76016354e56e39fa51892789851eee46ccf0a8fde |