Does the ALTER TABLE DROP PARTITION Query Trigger a Connector Re-Sync?

Question

When using binlog replication, does the ALTER TABLE <table_name> DROP PARTITION query trigger a connector re-sync?

Environment

All MySQL connectors.

Answer

The ALTER TABLE <table_name> DROP PARTITION query doesn't automatically trigger a re-sync for connectors using binlog replication. Our incremental syncs ignore this event. As a result, you must manually perform a re-sync to capture deleted partition data.

When you manually perform a re-sync, we mark the deleted data as _fivetran_deleted=TRUE to ensure the partitioned data is accurately reflected in the destination.