Skip to content
BENIBIX Learn

Snowflake Schema

Data🗄️ Storage & WarehousingDimensional Modeling

Like a star, but the side tables are split up. Each part is a small table.

Think of it like

It is like a tree. Big branches split into small ones, and those split again.

Example

The product table keeps a group key, not the group name. A second table holds the group names.

Why it matters

It saves space and keeps each name in one place. That helps when dimensions are huge or change often.

Definition

A snowflake schema is a star schema whose dimensions are split into more tables. A product table might point to a separate table of product groups. That table might point to a table of shop floors. This stops the same names being stored many times. The cost is more joins in every query. Drawn out, the branches look like a snowflake.
A star keeps each dimension in one table. A snowflake splits some of them again.

Common mistake

Thinking it is linked to the Snowflake product. The name is about the shape, and it is older than the company.

Key takeaways

  1. 1
    Split dimensions. Dimensions point to more tables.
  2. 2
    Less repetition. Each name is stored once.
  3. 3
    More joins. Queries take extra steps.

Compare