How is dbt_scd_id calculated?

Archive
1

We need to update our snapshot model to include additional columns but want to preserve historical data. The current snapshot config is check_cols=all. Does anyone know how dbt is calculating the dbt_scd_id value? Hoping to add the columns to the snapshot and recalculate dbt_scd_id for all existing data, then resume regular snapshots.

2

It’s an MD5 hash of primary_key and updated_at. This sort of question is most easily answered by looking at the materialization code inside the dbt codebase.

I found the answer above here and here!

1 Like
3

Thank you for the information this is perfect.