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 | 2794 | September 27, 2024 | |
| dbt-sqlserver 1.7.2 incremental model adding existing records with different version | 0 | 446 | February 18, 2024 | |
| Snapshot behavior | 1 | 1378 | October 10, 2023 | |
| Using DBT Archive | 2 | 4318 | September 14, 2018 | |
| Handling hard-deletes from source tables in Snapshots | 13 | 19809 | September 28, 2020 |