Does Fivetran Overwrite Existing Data in the Destination During the Initial Sync?

Question

I have set up a new connection, but my destination already contains data that matches the source. Will Fivetran transfer and overwrite that data during the initial (historical) sync?

Environment

All connectors and destinations

Answer

Yes, when you set up a new connection and we perform an initial sync, we transfer all selected data from the source to the destination, regardless of what's already there. During this sync, we:

• Insert new records
• Update existing records
• Soft delete records missing from the source by setting _fivetran_deleted to TRUE.

For more information, see our Sync Overview documentation.