Hi ,
I am a happy dbt core user and the most loved tool I am using is the snapshot for scd-type-2 dimension table. (Btw I am using check strategy) The problem I am facing is that the project I am in is a migration project and that means there is old data to be migrated also. So I want to backfill the snapshot table with previous data but the problem is I don’t know the logic behind creating the dbt_scd_id.
Can you help me please or at least recommend me a way to overcome this problem.
Best,
Hakan