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.