In computing, a snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.

What is the use of snowflake schema?

The purpose of a snowflake schema is to normalize the denormalized data in a star schema. This solves the write command slow-downs and other problems typically associated with “star schemas.” The snowflake schema is a “multi-dimensional” structure.

What is a snowflake schema and what is its purpose?

Snowflake Schema in data warehouse is a logical arrangement of tables in a multidimensional database such that the ER diagram resembles a snowflake shape. A Snowflake Schema is an extension of a Star Schema, and it adds additional dimensions. The dimension tables are normalized which splits data into additional tables.