What is Snowflake dimension? · Ultra Transcenders glossary

A dimension split across several linked tables, for example product, subcategory and category. Semantic models generally work better with one flattened table, since more tables mean longer filter paths and hierarchies cannot cross tables.

In the Ultra Transcenders books

DP-600 PL-300

Each book explains Snowflake dimension in context, with comparison tables and the common traps.

Terms in this definition

Event
Table in Log Analytics where entries from Windows event logs are kept.
FILTER
Returns just those rows of a table that meet a condition. In CALCULATE it handles conditions too complex for a Boolean filter argument, though a Boolean filter is faster whenever one will work.

See Snowflake dimension in the full glossary