This would allow you to constrain a metric by what table it comes from, the aggregation, what time granularities can be used, and what dimensions you can cut it by. You can also do a variety of other things (e.g. specify filters).
You would then effectively create SQL on the fly via:
select *
from {{ metrics.metric(
metric_name='average_order_amount',
grain='week',
dimensions=[],
) }}
Some of this can already be achieved in Metabase with metrics & segments - but firstly there are benefits to defining the logic further upstream, and secondly there are more constraints (i.e. how you cut the data).
They mention in their docs that "While dbt does not currently provide a BI experience for exploring these metrics, we’re working on a number of integrations with BI partners that will help unlock the full value of the metrics layer."
Are there any plans to integrate dbt metrics into Metabase?
Hello there,
I am also looking for this integration regarding a semantic layer with Metabase. In my case, we are using Dataform with Cube. It would be great to integrate it into metrics & segments of Metabase.
Are there any plans to integrate a semantic layer tool into Metabase?
I've used a text string for my filters - I haven't tried this yet with field filters (I'm sure there would be a way to make it work).
You can obviously do a lot more than just do dynamic date granularity above - you can pass different filters for text or timestamps etc.
Selecting which columns you'd want to aggregate the metrics by could be a bit trickier. You can do dynamic SQL in BigQuery but again I haven't tested this at all.
Congrats for this very smart hack! Will definitely try it out.
On my side, I've stopped using Metabase Metrics because they are not well developed: if you want 2 metrics in the same question, and those metrics have filters applied on the same fields, they will clash.
Eg: if you want # users = active and # users = inactive grouped by day, you'll get nothing.
I believe a product like Metabase should work in improving its connection with such an essential tool like dbt.
Metabase should definitely integrate with DBT, this is very painful not to a have a semantic layer nowadays in your BI tools. We may switch soon to an other tool if it does not come in the road map.
@luiggi - if possible, could you please share if this is on the roadmap or being planned? Few other visualization tools already support it.
We'd want as much analytics code as possible versioned, centralized, and tool independent. So it makes sense to build a semantic layer and then use it across visualization tools like Metabase, Tableau etc.
Would really love some kind of update on this! If it's nowhere on the roadmap, that's also good to know. We're strongly considering implementing semantic layer but without direct Metabase support we'd need another in-between tool to commit to and that's a factor to consider.
Hey guys, dbt semantic layer connection with a good metrics catalog is something that really interests us here. Actually, we are searching for tools that have it available, to simplify data discovery and enable business users to self-serve.
