🗄️Snowflake Schema
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
Common mistake
Key takeaways
- 1Split dimensions. Dimensions point to more tables.
- 2Less repetition. Each name is stored once.
- 3More joins. Queries take extra steps.