How to use dbt Snapshots to track data history

[@KahanDataSolutions]

Get my Modern Data Essentials training (for free) & start building more reliable data architectures www.ModernDataCommunity.com

[@jppbkm]

After going through the first 25% of the playbook and then stopping....here I am again googling answers to a work problem and finding your videos. Appreciate all the info and content. (Our issues was an incorrect unique_key setting on a table where the snapshot was created HUGE tables as a result.)

[@anbarasuramachandran2235]

Awesome. Helped in understanding the concept of Slowly changing dimensions (SCD) !

[@KahanDataSolutions]

Glad it helped!

[@dominicaleung7329]

thank you so much for your help. You make it very clear. I got mine snapshot working now.

[@KahanDataSolutions]

Glad it helped!

[@anushanr1355]

Hi, please make a detailed video on dbt analytics certification. As I am preparing for that it would be much helpful. Appreciate your works on data engineering

[@gauravsati1041]

Hi , How we can set DBT_VALID_TO default Null values to something other max number

[@rajasekharreddy113]

Thank you for the video. One question, Once snapshot is taken, it is best practice to use snapshot tables or source tables for working with other models? if snapshot is answer, how frequently, we have to update snapshot tables? or we have to trigger them for every update

[@rusttaf]

Hi, thanks for explaining this concept. Is there a way to set valid to date of ending record to d-1? This way using between in where condition will return 2 records instead of 1

[@nainatiwari4543]

Hey ,What have you mentioned in yml file? As I was trying to do this way but the staging model could not refer the snapshot due to some reason.

[@arbol41]

Thank for a very good content, I have a question how we can track deleted raw from the source ?

[@mrp12-ii]

soft deletes, CDC or snapshots would be the way to go.

[@BreathOfHopePodcast]

i ran from data science because of I knew I couldn't keep up with all the statistical readings

[@100sabh]

I find snowflake streams to be better than this concept

[@dimi727]

is it possible to partition snapshots (especially for Bigquery?)

[@mallninja9805]

You're a "Solutions Architect". Do you really need to nickel and dime your youtube audience to death with "courses" ?? You should feel shame.

[@ingenieroriquelmecagardomo4067]

why did you even bother writing this lmao, youre not even a content creator