Why is my PostgresSQL connector not capturing deletes?
Google Cloud PostgresSQL
XMIN as replication method does not allow capturing deletes but you can make use of the below workarounds to keep the data up-to-date in the warehouse :
- Table re-sync once in a while ( This will be tedious however, you can write some scripts to capture the tables that have deletes at your end to automate the process ).
- Connector Re-sync once in a few days ( can slow down updates and cause significant processing overhead on your PostgreSQL server ) to capture all historical data.
- Please refer to our docs for more information on other workarounds.
XMIN does not support capturing deletes.