The problem I’m having
I would like to use metricflow to define and manage metrics on a PostgreSQL database using dbt-core.
I’ve been able to set up and use dbt-core by itself, but whenever I try to bring in metrics I start getting errors about ‘metrics’ being undefined… and suggestions that I install the metrics package. This leads to a whole swirl about the differences in syntax between the way that metricflow, and the deprecated metrics package define metrics.yml etc…
Is this something that is supposed to work… and if so, what combination of packages is working for people?
The context of why I’m trying to do this
I have a lot of reports that need to have common metric definitions… ideally managed with something like metricflow
What I’ve already tried
installing and un-installing packages, formatting and re-formatting a ton of yml files upgrading python etc.
Some example code or error messages
2:29:34 Running with dbt=1.8.7
22:29:35 Registered adapter: postgres=1.8.2
22:29:35 Encountered an error:
Runtime Error
Compilation Error in model cm3_daily_report (models\cm3_daily_report.sql)
'metrics' is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with "dbt deps".(dbt-env) PS C:\...\metrics> dbt compile --no-version-check