Will I Lose Rows if I Split a Table and Perform a Historical Re-Sync?

Question

Will I lose rows if I split a table into multiple partitioned tables and perform a historical re-sync?

Environment

The following connectors:

• Google Cloud SQL for PostgreSQL
• Amazon RDS PostgreSQL

Answer

When you split a table into multiple partitioned tables and perform a historical re-sync, we update the old rows with _fivetran_deleted=TRUE and upsert all partitioned rows into the parent table. Therefore, you won't lose rows.

However, if you delete a partitioned table from your database before performing the historical re-sync, we won't be able to sync the corresponding data.