Why Are Historical Time Entries Marked _fivetran_deleted = TRUE After a User Is Removed?

Question

I removed a user from ClickUp, but their TIME_ENTRY records still exist in the source. After a re-sync, those records are marked _fivetran_deleted = TRUE in the destination. Why are they marked as deleted?

Environment

Connector: ClickUp

Answer

Fivetran re-syncs the TIME_ENTRY table by requesting time entries by user ID. When you remove a user from ClickUp, their user ID is no longer available for re-sync requests, and the ClickUp API does not provide deleted user IDs.

As a result, we cannot request that user's historical time entries, so those records are not returned during the re-sync. We then mark them as deleted in the destination by setting _fivetran_deleted = TRUE.

There is no available workaround.