https://linen.dev logo
#plugins-general
Title
# plugins-general
n

nicholas_van_kuren

09/16/2022, 9:23 PM
Hello, I am using the transferwise target-postgres plugin and trying to understand how I can truncate tables in my target postgres database prior to loading data on each run. I have the tap setup as full-replication and have also tried using the
--full-refresh
flag, but on each run all of the records from my source are loaded again so I end up with duplicates. I do not have reliable replication IDs as described in the Singer documentation. There is no modified date or incremental ID in the source tables to track the latest record for upserts.