HubSpot Data Model and Schema Information
The following table lists the HubSpot resources and the corresponding table names generated by RudderStack in your warehouse:
| HubSpot Resource | RudderStack Table Name | Description | Updates | Dependency |
|---|---|---|---|---|
| Blog Posts | blogs_posts | Information about the blog posts | Yes | - |
| Blog Authors | blogs_authors | Information about the blog's authors | No | - |
| Blog Comments | blogs_comments | Information about the blog comments | Yes | - |
| Blog Topics | blogs_topics | Information about the blog topics | No | - |
| Blogs | blogs | Information about the overall blog | No | - |
| Campaigns | campaigns | Information about the HubSpot campaign data | No | - |
| Companies | companies | Information about the HubSpot company data | Yes | - |
| Companies Contacts | companies_contacts | Information about the HubSpot company contacts | Yes | companies |
| Contact Lists | contacts_lists | Information about the HubSpot contact lists used to segment contacts into groups. Due to Hubspot’s API limitations, this needs to be fully synced every time. | No | - |
| Contacts | contacts | Information about HubSpot contacts | Yes | - |
| Contacts Identities | contacts_identities | Information about the HubSpot contact identities to identify a contact | Yes | contacts |
| Contacts in Lists | contacts_in_lists | Information about the HubSpot contacts and lists data. Due to Hubspot’s API limitations, this needs to be fully synced every time. | No | contacts_lists |
| Deals | deals | Information about the HubSpot deals | Yes | - |
| Deals Companies | deals_companies | Information about the HubSpot company deals | Yes | deals |
| Deals Contacts | deals_contacts | Information about the deals related to HubSpot contacts | Yes | deals |
| Deals Deals | deals_deals | Information about the HubSpot deals and the related data | Yes | deals |
| Keywords | keywords | Information about the HubSpot keywords | No | - |
| Owners | owners | Information about the HubSpot owners | No | - |
| Workflows | workflows | Information about the HubSpot workflows. Along with the contacts and emails, workflows are essential to automating Hubspot marketing. | No | - |
RudderStack syncs all the historical data during the first sync. Also, it retains all the deleted records in the tables.
Contact Us
For more information on the data model the schema information, you can contact us or start a conversation on our Slack channel.