# Snapshots failing with Duplicate DBT\_SCD\_IDs

**URL:** <https://discourse.getdbt.com/t/snapshots-failing-with-duplicate-dbt-scd-ids/8671>\
**Category:** Help\
**Tags:** snapshots, snowflake\
**Created:** [June 12, 2023, 1:09pm UTC](https://discourse.getdbt.com/t/snapshots-failing-with-duplicate-dbt-scd-ids/8671 "2023-06-12T13:09:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![og\_dbt\_data](https://avatars.discourse-cdn.com/v4/letter/o/8dc957/32.png) [@og\_dbt\_data](https://discourse.getdbt.com/u/og_dbt_data)\
**Post date:** [June 12, 2023, 1:09pm UTC](https://discourse.getdbt.com/t/snapshots-failing-with-duplicate-dbt-scd-ids/8671/1 "2023-06-12T13:09:36Z")

</div>

## 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.

---

<div class="post-metadata">

**Author:** ![the\_consultant](https://avatars.discourse-cdn.com/v4/letter/t/a87d85/32.png) [@the\_consultant](https://discourse.getdbt.com/u/the_consultant)\
**Post date:** [February 9, 2024, 11:36am UTC](https://discourse.getdbt.com/t/snapshots-failing-with-duplicate-dbt-scd-ids/8671/2 "2024-02-09T11:36:17Z")

</div>

Same here, using BigQuery. It may be worth noting that columns not within the check\_cols condition ARE changing, but we don’t want changes in those columns to constitute a new row version.