Since snapshot is implemented as a materialization, it is perfectly fine to use it as a scd2 type loading
on models, and it works as expected. It even makes sense for loading dimension tables in data marts.
Why is the differentiation between snapshots and models other than the fact that a snapshot is not fully refreshable?
1 Like