Why would a Snowflake Architect choose a star schema model instead of a 3NF model when designing a data architecture to run in Snowflake?
A star schema organizes quantitative facts with descriptive dimensions, making it well suited to BI analysis that aggregates facts by dimensions and supports drill-down. Its simpler dimensional structure can also provide a flattened, user-friendly data view for a defined end-user audience. Snowflake documentation recommends beginning business data modeling with a simple star schema and describes dimensions as the context used to group and analyze metrics.
Community Discussion