Why Are Tables Re-syncing without Being Triggered from Fivetran
Question
Why are tables re-syncing without being triggered from Fivetran in Settings or without checking on re-sync?
Environment
SQL Databases:
- MariaDB
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- SAP HANA
- Snowflake
- Amazon DynamoDB
- MongoDB
- DocumentDB
Answer
Schema changes in the source database are the most common trigger for a full table re-sync. Automatic full table re-syncs are scheduled for SQL databases in the following circumstances as noted in our Automatic re-sync section.