Question
The total number of records in a destination does not match the source even after filtering out the deleted records using the _fivetran_deleted column.
Environment
Connector: PostgreSQL
Answer
Please trigger a historic table resync for the records to match.
Cause
That must be a Primary Keyless table. Please refer to this section to know how we handle changes to tables without a primary key.