Why Was a Deleted Record Synced to My Destination?

Question

I created and then deleted a record before a sync ran. Why was it synced to my destination?

Environment

All connectors that use soft delete mode.

Answer

When a record in your source is created and subsequently deleted, each event is considered a separate transaction and stored in the source's system change tracking mechanism.

When this occurs, we extract both transactions, process them, and then sync the record to your destination with _fivetran_deleted = TRUE.