Create models based on MetricFlow queries #11119
michelbouchou
started this conversation in
Ideas
Replies: 1 comment
-
Why is this a discussion and not a feature request? This sounds very good. It would make way more sense to be able to use metrics inside of models, they would be like a macro. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Current behavior
I am using MetricFlow with dbt-core.
dbt-core is not meant to execute saved-queries based on created metrics but only allow to generate SQL. Only dbt Cloud handles the export functionality.
Idea
I suggest to add a macro that can compile SQL based on a saved-query and handle it in a new model. It would allow dbt-core users to have a better experience using MetricFlow by handling the execution and new transformation after the metric definition part.
Some user published a similar macro on Github a couple of months ago but this is not working correctly and won't be maintained as part of dbt and MetricFlow :
https://github.com/DJLemkes/dbt-metric-utils
Beta Was this translation helpful? Give feedback.
All reactions