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.
It’s an MD5 hash of
updated_at. This sort of question is most easily answered by looking at the materialization code inside the dbt codebase.
Thank you for the information this is perfect.