Hello. We have append and load table in source. We are picking the latest updated version of record on unique key and passing them to snapshot. If there is any update dbt is working as expected but in case of unchanged records dbt is end dating those records and creating a new version for the same records with new updated date. We want to maintain the old record itself as there is no update so no reason for it to be end dated. It would be much appreciated if anyone can help with this.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| DBT Snapshot creating duplicate rows even though there's no change in source data | 6 | 3815 | September 27, 2024 | |
| DBT Snapshots not handling Multiple Updates to the Same Unique Key | 0 | 110 | September 13, 2024 | |
| Snapshot behavior | 1 | 1801 | October 10, 2023 | |
| Building snapshots on an append only table. | 0 | 183 | August 20, 2024 | |
| [ClickHouse × dbt] Snapshot keeps writing an extra version after every change | 0 | 16 | July 23, 2025 |