We know you sometimes need to overwrite an existing table to make sure you have everything you need — when, for example, an operation is performed on a source table that our incremental replication can’t detect (e.g., TRUNCATE). Until now, you could only fix the resulting data integrity issue by re-syncing an entire database.
That’s why we’re introducing Table Re-Sync, which gives you the ability to fix these issues at the table level whenever you see them. It’s a much simpler and more agile process.
Table Re-Sync is available for the following connectors:
- Salesforce
- NetSuite
- MySQL
- Oracle
- Postgres
- Zuora
- SQL Server
To use Table Re-Sync, just go to your connector details page and hover over the table you want to re-sync. Note that re-syncing a table will pause incremental updates until the historical data is loaded.
![](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619194ec06154e01353a8288_6141ce568652d42e7fdd034a_static-instruction.jpeg)
Here's the full process:
![](https://cdn.prod.website-files.com/6130fa1501794e37c21867cf/619194ecb88f693ff420c134_6141ce560062dcc1c5aec7d8_animated-instruction.png)