What Is the Difference Between the is_deleted and _fivetran_deleted Columns?

Question

What is the difference between the is_deleted and _fivetran_deleted columns?

Environment

Connector: HubSpot

Answer

Fivetran sets the is_deleted column to TRUE in the HubSpot CONTACT table when HubSpot sends a deletion event through a webhook. We use this column to indicate that the source explicitly marked the record as deleted.

We set the _fivetran_deleted system column to TRUE when the source no longer returns the record during a re-sync. This column indicates that the record has been removed or is otherwise missing from the source. For more information, see our System columns documentation.