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:

• CockroachDB
• MariaDB
• MySQL
• Oracle
• PostgreSQL
• SQL Server
• SAP HANA
• Snowflake

NoSQL Databases:

• Azure Cosmos DB
• Azure Cosmos DB for MongoDB
• Amazon DocumentDB
• Amazon DynamoDB
• Elasticsearch
• Firebase
• MongoDB
• OpenSearch

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 databases in the following circumstances as noted in our Automatic re-sync section.