How Does Workday RaaS Handle Deletes When Dynamic Parameters Are Enabled?

Question

How does Fivetran handle deletes when dynamic parameters are enabled for a report and the sync strategy is set to Sync updates from last sync?

Environment

Connector: Workday RaaS

Answer

Fivetran detects deletes by comparing the primary keys in your destination with the primary keys returned by the source.

With dynamic parameters disabled

During each incremental sync, we re-sync the full report. This allows us to identify records that no longer exist in the source and mark them as _fivetran_deleted = TRUE.

Dynamic parameters enabled with Sync updates from last sync

When you configure a connection with this strategy, we sync only records from the last sync to the current sync. We don't retrieve the full dataset, so we can't reliably identify source records that were deleted outside the requested time window. As a result, deleted records may remain in the destination and are not marked as _fivetran_deleted = TRUE.

To detect deletes, edit your report configuration and set the Enable Dynamic Parameters toggle to OFF. We will then re-sync the full report during each incremental sync and flag deleted records. For more information, see our Workday RaaS sync strategy.