The Destination Has More Records Than the Source Database
Question
The total number of records in a destination does not match the source, even after filtering the deleted records using the _fivetran_deleted column.
Environment
Connector: PostgreSQL
Answer
Trigger a historical table re-sync for the records to match.
Cause
This is often caused by tables without a primary key. For information on how tables without a primary key are handled in Fivetran, see our PostgreSQL documentation.