We have our HubSpot and Salesforce data in our Redshift warehouse. When trying to join the data, currently the only way to join is using email address. This causes issues because in the warehouse, it seems contacts with the same email address are not merged, instead there are two (or more) contacts with the same email address and different vid values. When I log into HubSpot, I only see one contact per email address since email is the unique identifier in HubSpot (vid is the unique identifier in the warehouse). I see two solutions here:
Add the Salesforce contact ID to HubSpot.
Change how the consolidation works in the warehouse to use email address instead of vid, which would result in data loss but be analogous to how HubSpot works.
Has anyone had this issue in the past? How would you recommend proceeding? I am hesitant to change our consolidation and lose past data and don't know if it is possible to add the Salesforce Contact ID in HubSpot.