SnowPro Advanced Architect

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.