# Snowflake Schema

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

**Field:** Data Engineering  
**Category:** Storage & Warehousing

## Think of it like

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

## 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.

## 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.

## Common mistake

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

## Three principles

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

## Related terms

- [Star Schema](https://learn.benibix.com/term/data/star-schema)
- [Dimension Table](https://learn.benibix.com/term/data/dimension-table)
- [Database Normalization](https://learn.benibix.com/term/development/normalization)
- [Dimensional Modeling](https://learn.benibix.com/term/data/dimensional-modeling)

## Told apart from

- [Star Schema vs Snowflake Schema](https://learn.benibix.com/compare/star-schema-vs-snowflake-schema): People think a snowflake schema is better because it stores less. It splits dimensions into more tables, so each name sits in one place. A star schema keeps each dimension in one wide table. That means fewer joins and simpler queries, which is why most teams pick the star.
- [Snowflake vs Snowflake Schema](https://learn.benibix.com/compare/snowflake-vs-snowflake-schema): People think the snowflake schema is named after the Snowflake product. It is not. The schema is a way to lay out tables, and the name comes from its branching shape. Snowflake is a cloud data warehouse. You can build a star or a snowflake schema in it.

![Left: a star schema, with a sales fact table in the middle and four dimension tables around it, each joined straight to the fact. Right: a snowflake schema, where the product dimension is split further into a category table.](https://learn.benibix.com/diagrams/star-vs-snowflake-schema.svg)

---

Source: https://learn.benibix.com/term/data/snowflake-schema
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
