For sale: data company, worn out.
you must have not read many real MBA case studies. This is nowhere as dry.
I like the part where you mention dbt Metrics. I fully agree with everything you said and would like to add up that dbt should leave the semantic layer to players who are more experienced with it.
While talking about semantic layers, I think there should be a standardization of this mighty feature. Unfortunately, semantic layers do not follow any standardization now and for that, they become vendor locks.
Really enjoy reading your posts, thanks for doing this every week!
Having only seen a simple demo of dbt it just does not seem to do much at all. And I do not see how it would possibly scale to create an ETL system for hundreds of tables and tens of thousands of fields.