How Can I Switch Back to the Time Travel Sync Method?

Question

I received an alert that a table has switched to the Fivetran Teleport Sync method because Time Travel Sync is no longer possible. How can I switch it back?

Environment

Connector: Snowflake

Answer

To restore Time Travel Sync for tables switched to Fivetran Teleport Sync:

1. In Snowflake, enable change tracking for the table:

   ALTER TABLE <table_name> SET CHANGE_TRACKING = TRUE;
   

2. In Fivetran, go to your Snowflake connection page.
3. Select the Schema tab.
4. Find the affected table, then click Re-sync.
5. In the confirmation pop-up window, click Start re-sync.