Like a star schema, except that at least one dimension is normalised out into a chain of linked tables; for instance category, subcategory and product may each get their own table.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Snowflake schema in context, with comparison tables and the common traps.
Terms in this definition
- LIKE
Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
- Star schema
A model for analytics named after its diagram's shape: dimension tables describing the data surround, and link to, one central fact table holding the measures.
- EXCEPT
A set operator that gives the rows in one query's result that the second query doesn't return.
SELECT * EXCEPT (...)uses the same word to omit columns. - LEAST
Pass up to 254 expressions to this T-SQL function and it hands back whichever is smallest. Both Fabric Warehouse and SQL analytics endpoints support it.
- Get
Key Vault permission on secrets that allows a single secret to be read; App Service Key Vault references need nothing beyond it.
- Event
Table in Log Analytics where entries from Windows event logs are kept.