The problem I’m having
My snapshots are failing due to duplicate rows already existing in the snapshot table.
However, when I query the table, I see duplicate dbt_SCD_IDs.
My source data does not have duplicates.
I’m using a check_col strategy, and the columns are not changing.
What I’ve already tried
I’ve ensured I have no duplicates in the source.
I’ve ensured the the columns are called out that I want to check.
I’ve previously tried the timestamp method and it also failed.