Dbt-Snapshot

4. SCD - When a Customer Moves, Where Were Past Orders Shipped?

When dimension data changes, do you overwrite history or preserve it? We implement SCD Type 1, 2, and 3 differences in SQL, then build a production pattern with dbt snapshot.