Re-Sync Your Tables With Fivetran

Selectively re-sync tables to get the data you need, when you need it.
December 6, 2018

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.

Here's the full process:

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Blog

Re-Sync Your Tables With Fivetran

December 6, 2018
Re-Sync Your Tables With Fivetran
Topics
No items found.
Share
Selectively re-sync tables to get the data you need, when you need it.

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.

Here's the full process:

No items found.

Related blog posts

No items found.
No items found.
No items found.

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.