ataft
commented
2 years ago Very cool, I'd love to see this grow with more complex scenarios like the unified star schema. Generally, I would want separate this out as to not overcomplicate things for beginners. But then add on a bridge and talk about that in the documentation. I also want to make sure that the "when" and "why" questions are answered. E.g. when and why should I do dimensional modeling instead of one-big-table (OBT), or when do bridge tables makes sense to introduce.
I'll think about this some, but also would love the community to come together on this project. The beauty of this being Github and dbt, rather than in a book, is that everyone can run real examples. I think it's a huge learning opportunity.
fabrice-etanchaud
As dbt metadata contains relationships and metrics, one can catch up traps as defined by francesco puppini in his book written with bill inmon. Then, your project could help build the unified star schema (the famous bridge table). It's really a challenging project you envision ! I wonder how it could integrate the upcoming dbt metrics server !