Hey folks!
I’m fairly new to HubSpot after working with Salesforce for many years. The transition has been challenging so far.
I’m currently working on extracting HubSpot data into our analytics warehouse to create dashboards in Power BI. However, I keep running into problems when trying to connect different HubSpot objects together.
For instance, I need to link company records with opportunity records, but I can’t figure out what fields to use as primary and foreign keys for the relationship. The data structure isn’t clear to me.
I’ve searched everywhere for documentation on HubSpot’s standard database schema but haven’t found anything comprehensive. I also don’t see obvious ways to create relationship fields between different object types.
Has anyone here successfully mapped out these object relationships? Any guidance would be really helpful!