Questions about dynamic measures and experience with dbt semantic layer

Hey everyone!

My team is currently deploying a new DWH system for our client based on the ClickHouse DB. Although we are still undecided between the visualization tools—Superset with direct query or Power BI with import mode (these are the only two possible scenarios with ClickHouse anyway) - we have managed to determine the layers in our new data warehouse: staging with views, core with a star schema and data marts with wide tables.

We are uncertain about the following:

1. Based on these layers, where should we place our dynamic measures, which could later be used in Superset (such as net sales, COGS, etc.)?

2. How can we leverage the dbt Semantic Layer (Metric Flow) and incorporate the same definitions of those measures (considering that we are working with dbt Core and this edition has limited functionalities regarding the semantic layer)? Can you recommend some resources, maybe some step-by-step tutorials? For example something like this: https://docs.getdbt.com/docs/build/sl-getting-started but focused on dbt Core.

3. In general, is Metric Flow limited to certain types of databases or not?

If anybody has any experience or recommendations regarding the above questions, please let me know. Thanks :)

5 comments

Modern Data Community

Public group

A community of data professionals building architectures with modern tools & strategies.

Leaderboard (30-day)