dbt (data-build-tool) - How to use dbt Snapshots to track data history

All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com ----- Some data points naturally change over time, but it happens slowly. Unsurprisingly, this is referred to as a "slowly changing dimension" or SCD. This is a common data modeling scenario but can take a while to get right. But if you use dbt, you can take advantage of their built-in Snapshots feature. Snapshots require just a few configurations to set up and the result is a new table that tracks historical changes just like a SCD. So in this video, you'll learn more about what dbt Snapshots are and how to easily add them to your project. Enjoy! Timestamps: 0:00 - Intro 0:51 - What are Snapshots? 1:57 - Review Scenario 3:08 - Best Practices 3:55 - Create a Snapshot 7:45 - Add New Data 9:29 - Reference Snapshot in a Model Title & Tags: How to use dbt Snapshots to track data history #kahandatasolutions #dataengineering #dbt