Why is my PostgreSQL connector not capturing deletes?
If you are using XMIN as a replication method, this mechanism does not allow us to recognise deleted rows at all (for more information, see our XMIN documentation).
The preferred method to replicate row deletions from your data source is to use Logical Replication.
If logical replication is not an option for you, you can use one of the below workarounds to keep the data up-to-date in the warehouse:
Re-sync via your own automated script using the Re-sync Connector Table data API endpoint.
See our documentation for workarounds using triggers or adding an extra column to your source.
XMIN does not support capturing deletes.