Hubspot Connector Should Sync Deleted Records at the same frequency as changes
Which connector?:
Hubspot
Additional details:
A sync at a frequency other than 1x every 24 hours is useless if deleted records are not synced at the same time. Currently, deleted records are synced only 1x every 24 hours for Hubspot records.
Additionally, a sync missing deleted records is not a sync at all and should not be described as a sync. The missing data corrupts the destination data warehouse and the incorrect 'sync' terminology sets expectations that do not match reality.
For example, we currently bring in Hubspot data hourly in order to show us near realtime pipeline. If a user deletes a million dollar line item to replace it with a different sku on a quote, our pipeline will show an increase of a million dollars because the deleted line item is not recognized as deleted in the hourly sync. That discrepancy is significant, and our only answer is that Fivetran doesn't work well. That is not a good look for us or for Fivetran.
Requested functionality:
Regardless of the sync interval configured by a fivetran admin, every time a sync is performed with Hubspot tables, all deleted records are recognized and synced along with changed records.
Please sign in to leave a comment.
Comments
0 comments