Does the _fivetran_synced Column Update for Deletes?

Question

Does the _fivetran_synced column update to reflect source-side deletes?

Environment

All connectors

Answer

The _fivetran_synced column updates for individual (soft) deletes, such as when a single row is deleted at the source. However, it doesn't update for bulk operations, such as TRUNCATE or mass-deletes that happen during re-syncs. For more information, see our System columns documentation.