How Can I Recover a Missing MongoDB Document Without Performing a Historical Sync?

Question

A document in my MongoDB source is missing from the destination. Can I sync the missing document without triggering a historical sync for the entire collection?

Environment

Connector: MongoDB

Answer

To recover the missing document without performing a historical sync, run a replaceOne() operation on the source document using the document's current contents. The replaceOne() operation emits a MongoDB replace change stream event, which Fivetran processes as an upsert. This allows us to recreate the missing row in the destination.

After the next successful sync, verify that the record appears in the destination.