Edit on GitHub
The Destination Has More Records Than the Source Databaselink
Questionlink
The total number of records in a destination does not match the source, even after filtering the deleted records using the _fivetran_deleted
column.
Environmentlink
Connector: PostgreSQL
Answerlink
Trigger a historic table re-sync for the records to match.
Causelink
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.