Skip to content
BENIBIX Learn

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.

Data🗄️ Storage & Warehousing

Snowflake

A warehouse in the cloud. You pay for the space and the work apart.

Snowflake is a cloud data warehouse sold as a service. It keeps storage and computing apart. Your data sits in one shared store. You start compute clusters, called virtual warehouses, to run queries on it. Each one can be sized up, sized down or paused, and you pay for the time it runs.

Example
A team runs reports on a small warehouse and a big monthly job on a large one. Both read the same tables at once.
Why it matters
Teams can query the same data without slowing each other down. A paused warehouse costs nothing for compute.
Full entry
Data🗄️ Storage & Warehousing

Snowflake Schema

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

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.
Full entry

In one line

Snowflake
A warehouse in the cloud. You pay for the space and the work apart.
Snowflake Schema
Like a star, but the side tables are split up. Each part is a small table.