thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Snowflake Schema

A dimensional model whose dimension tables are normalized into multiple related tables, such as Product to Subcategory to Category.

Definition

Snowflaking reduces redundancy in dimensions but adds joins and complexity for users and BI engines. The schema has nothing to do with the Snowflake data platform.

Exam tip

Snowflake schema = normalized dimensions. Don't confuse it with the Snowflake company.

Don't confuse it with

Related terms