Question
Why are tables resyncing without being triggered from Fivetran in Settings or without checking on resync?
Environment
SQL Databases:
- MariaDB
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- SAP HANA
- Snowflake
- DynamoDB
- MongoDB
- DocumentDB
Answer
Schema changes in the source database are the most common trigger for a full table resync. Automatic full table resyncs are scheduled for SQL databases in the following circumstances as noted in out Documentation: