Which Snowflake data-modeling approach is intended for BI queries?
A star schema organizes measurable facts around directly related dimension tables, which simplifies the joins and aggregations commonly used in business-intelligence reporting. Snowflake documentation recommends starting with a simple star schema when mapping a business data model for BI use.
Community Discussion