how data marts works in Snowflake

Question

Normal data warehouses we create data marts for different teams. How does it differ in Snowflake? In snowflake, we can create a database and share it with others. Can someone please explain data marts behavior in snowflake? Do we need to crate separate data marts like we normally do or any other approach use in snowflake?

Answer 1

Both the approach has pros and cons, I prefer to keep one persisted Common Datamart and then virtual team/function/user specific Data marts. This is because sometime you not only want to filter out some data but also you may want to expose limited columns to user specific Data mart.