Refers to a model where the attributes are separated out into smaller lookup tables linking back through lower level entities in the model. Tradeoff in size of tables browsed to obtain prompt element responses, versus number of joins in report query. Advantage of snowflaking is less apparent with use of element caching