Hi, I have question. If rows in my source system g...
# troubleshootingw
willi_langlitz
01/17/2023, 9:32 AMHi, I have question. If rows in my source system gets deleted and I want them also to vanish in my target system, so that I have a 1:1 replication of my source system. Should I just use FULL_TABLE replication in combination with hard_delete? Or is there a more efficient way?
v
visch
01/17/2023, 2:25 PMShould I just use FULL_TABLE replication in combination with hard_deleteIs what I do
Or is there a more efficient way?I wouldn't say more efficient but another way is to use activate version. see https://github.com/meltano/sdk/issues/18
t
thomas_briggs
01/17/2023, 2:30 PMLOG_BASED replication is good for this
thomas_briggs
01/17/2023, 2:30 PMWhether or not that's available depends on your source DB tho
w
willi_langlitz
01/31/2023, 5:29 PMUnfortunately it is not available because the source DB is a PostgreSQL replica.