Скачать или смотреть How to use dbt Snapshots to track data history

FREE Modern Data Checklist to give you clarity → https://bit.ly/kds-checklist
Project-based training to help you level-up → https://bit.ly/simple-stack
Consulting to help you implement → https://bit.ly/kds-consulting

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