# Snapshot duplicates issue

**URL:** <https://discourse.getdbt.com/t/snapshot-duplicates-issue/18756>\
**Category:** Help\
**Tags:** snapshots, dbt-core\
**Created:** [March 23, 2025, 8:56pm UTC](https://discourse.getdbt.com/t/snapshot-duplicates-issue/18756 "2025-03-23T20:56:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![oli](https://avatars.discourse-cdn.com/v4/letter/o/2bfe46/32.png) [@oli](https://discourse.getdbt.com/u/oli)\
**Post date:** [March 23, 2025, 8:56pm UTC](https://discourse.getdbt.com/t/snapshot-duplicates-issue/18756/1 "2025-03-23T20:56:28Z")

</div>

Help please, I have strictly followed the dbt snapshot documentation for creating a simple snapshot, but no matter what I try, I always ended up getting the below “duplication” error.  
00:59:13 Completed with 1 error and 0 warnings:  
00:59:13  
00:59:13 Database Error in snapshot snap\_representative (snapshots/snap\_representative.sql)  
100090 (42P18): Duplicate row detected during DML action  
Row Values: [redacted]  
compiled code at target/run/snap\_representative.sql  
00:59:13  
00:59:13 Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1

---

<div class="post-metadata">

**Author:** ![a\_slack\_user](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/a_slack_user/32/1629_2.png) [@a\_slack\_user](https://discourse.getdbt.com/u/a_slack_user)\
**Post date:** [March 24, 2025, 4:01am UTC](https://discourse.getdbt.com/t/snapshot-duplicates-issue/18756/2 "2025-03-24T04:01:58Z")

</div>

You may be having duplicate rows in the data, please check those rows once. Copy the queries from the dbt logs and run those queries in your data warehouse and check for duplicates.

Note: `@Manikanta Divvela` originally [posted this reply in Slack](https://getdbt.slack.com/archives/CBSQTAPLG/p1742788903262439?thread_ts=1742763412.582399&cid=CBSQTAPLG). It might not have transferred perfectly.

---

<div class="post-metadata">

**Author:** ![a\_slack\_user](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/a_slack_user/32/1629_2.png) [@a\_slack\_user](https://discourse.getdbt.com/u/a_slack_user)\
**Post date:** [March 24, 2025, 4:44am UTC](https://discourse.getdbt.com/t/snapshot-duplicates-issue/18756/3 "2025-03-24T04:44:18Z")

</div>

[https://youtu.be/yuat80nc5Ng|https://youtu.be/yuat80nc5Ng](https://youtu.be/yuat80nc5Ng%7Chttps://youtu.be/yuat80nc5Ng)

Note: `@Jeremy Yeo` originally [posted this reply in Slack](https://getdbt.slack.com/archives/CBSQTAPLG/p1742791450059049?thread_ts=1742763412.582399&cid=CBSQTAPLG). It might not have transferred perfectly.