seek
Jun 22, 2022

What’s that one thing you wished dbt had?

1 Reply

I really wish dbt had more support for the semantic (metadata) layer. It already has support to add metadata to models via YAML, e.g. label, description, joins, data type. However, it would be great if there were a way to standardize metadata and make it more "active". For example, the dbt Cloud metadata API could provide hooks to update metadata. Perhaps even a metadata management UI, as I know managing YAML text is a pain point for many people. An improved semantic layer can enable "semantic-free" downstream tools that all speak the same language. Here's an article expanding on this concept: https://towardsdatascience.com/semantic-free-is-the-future-of-business-intelligence-27aae1d11563. As an example, here are docs showing how the FlexIt Analytics BI tool integrates with dbt for "semantic-free" BI: https://learn.flexitanalytics.com/docs/dbt - Edited

6 days ago
Please login to reply