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