Will Migrating a Table to Another Connector Trigger a Historical Re-Sync?

Question

I have two connectors configured to access the same source but with different tables enabled. If I disable a table in one connector and enable it in another, will the table undergo a historical re-sync?

Environment

All connectors

Answer

We maintain a cursor that tracks sync progress for each connector. It acts like a bookmark, ensuring we only fetch new or updated data during each sync. Cursors are unique to each connector. Therefore, when you enable a table for the first time, it will undergo a historical re-sync, regardless of whether another connector has already synced data for the same table.