Snowflake Schema

What is a Snowflake Schema?

A Snowflake Schema is a more complex variation of the Star Schema due to the fact that the Dimensions in this Data Warehouse structure are normalized into multiple related tables. Similar with the Star Schema, the Snowflake Schema derived its name from its appearance, which resembles that of a snowflake.