Issue with dealstage values not matching between deals_properties_history and deals stream in Airbyte

Summary

Airbyte (self-hosted) is not capturing some changes in dealstage values between deals_properties_history and deals stream from Hubspot. Approximately 100 deals out of 3000+ have mismatched stages. User seeks advice on resolving this issue and recommendations on correctly utilizing Hubspot history tables.


Question

Hi there :slightly_smiling_face:

We’re using Airbyte (self-hosted) to extract data from our Husbpot instance (private app connection method). The connection runs every two hours.

I am comparing the latest dealstage available for any given deal in the deals_properties_history stream against the dealstage value in the deals stream. There are approx. 100 deals (out or 3000+) for which the stages do not match. It seems that the deals_properties_history does not catch some changes (see screenshot of our Hubspot Instance versus the extracted table for the same deal, filtered on dealstage property).

My questions are:

• Have any of you experienced a similar issue? If yes, did you resolve it and how?
• We rely a lot on the hubspot history tables, what do you recommend to use them correctly ?
Any help will be greatly appreciated! :pray:
Thank in advance



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["airbyte", "self-hosted", "hubspot", "dealstage", "deals_properties_history", "deals", "data-extraction", "mismatch", "history-tables"]