How are deleted records dealt with when syncing HubSpot streams?

The knowledge sources don't contain specific information about how deleted records are handled for HubSpot streams in Airbyte. However, I can explain the general principles that apply based on the available documentation: General Handling of Deleted Records in Airbyte Incremental Sync (without CDC) For most API-based sources (like HubSpot), standard incremental sync does not propagate deletions to the destination. This is because incremental syncs query the source for records inserted or modified since the last sync — deleted records are simply not returned by such queries, so they remain in the destination. [Incremental Sync Tutorial] CDC (Change Data Capture) CDC is primarily available for database sources (e.g., MySQL, PostgreSQL). When CDC is enabled, deletions are captured from transaction logs and flagged in the destination using the

_ab_cdc_deleted_at

metadata column. [CDC Docs] API Sources with Deletion Flags Some API-based connectors can surface deleted records if the source API exposes a deletion flag. For example: • The Salesforce connector returns deleted records with an

IsDeleted

flag during incremental syncs. • The Shopify connector has a dedicated

IncrementalShopifyStreamWithDeletedEvents

class that fetches destroyed records via a separate events API. Whether HubSpot exposes such a flag depends on the HubSpot API itself, and the knowledge sources do not contain specific details about the HubSpot connector's deletion handling. Workarounds If you need the destination to mirror the source (including deletions), your options are: 1. Full Refresh Overwrite sync mode — rewrites the destination table entirely on each sync. 2. Refresh Sync — resets the cursor and re-syncs all records, allowing you to detect deletions by comparing

_airbyte_generation_id

values. [Refreshes Docs] For HubSpot-specific deletion behavior, I'd recommend checking the Airbyte HubSpot connector documentation directly, as the knowledge sources here don't cover it explicitly. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.