Does Snowflake Warehouse needs to be modeled? Is the Dimension modeling still relevant in Snowflake?
My organization is migrating from a traditional warehouse and migrating(building from scratch) to Snowflake. Does Snoflake still needs to be modeled based on the dimensional modeling?. is there any data modeling tool for snowflake that maintains versioning of tables?
1. With the advance of MPP and columnar storage is the traditional warehouse concept of having star schema’s still valid?.
2. Storage cost’s being cheap and joins between tables costing more do we need to have dimension tables?
3. How do we manage SCD2 tables in the new architecture?
4. Are the views on the staging tables going to replace the actual star schema tables?
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds