When using postgres tap and target (transferwise) ...
# plugins-general
When using postgres tap and target (transferwise) with FULL_TABLE sync. I'm realizing it's keeping all the data every time the sync happens. Is there some best practice to keep around the last few syncs or remove old data? I can't use log based because GCP CloudSQL and need to get all the columns in for Incremental. I tried looking through the meltano docs and stitchdata https://www.stitchdata.com/docs/replication/replication-methods/full-table#limitations but couldn't find anything.