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-converter
Upgrading to dbt v1.6 spec
- Navigate to the root of your dbt project.
- Install the
dbt-converter
package using pip. Note that the converter requiresdbt-core==1.5
. You may need to update the version range for thedbt_metrics
package. - Run
dc 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.3b1.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | caa99d30fb4a046755b9589f57ffd96241955fed458fa17d9febacb6ac624228 |
|
MD5 | e1b110205f6bb357eef128c6c222ca3b |
|
BLAKE2b-256 | 79a954cb5b329ba8dc88f4dcab4e296ab86872c952773ef9820d53cbd7b8c7bf |
Close
Hashes for dbt_metrics_converter-0.1.3b1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0cca1c5c54f2b618534630b662c0dadd6e9805182efbfd9f9e9f9dec791e289e |
|
MD5 | 621a4c28735cd1e2b1befd4a7dc67078 |
|
BLAKE2b-256 | fbb42e591353503742df33630aff53729408ad83f4335cdac50b486b6644843e |