AI engineering glossary · Data engineering
What is snowflake schema?
Snowflake schema: A variation of the star design in which dimension tables are broken into further related tables to remove repetition, for example splitting product into category and brand. It saves space but needs more joins.
Snowflake schema: an example
A product dimension links to a separate category table instead of repeating category names in every product row.
Related terms
More Data engineering terms
Where you learn it
Snowflake schema is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.