Missing HubSpot Columns, Tables, or Values

Issue

HubSpot columns, tables, or values are missing from the destination.

Environment

Connector: HubSpot

Answer

Missing empty columns or tables

Fivetran doesn't support creating empty tables and columns for HubSpot connections, meaning we don't sync columns or tables to the destination if there is no applicable data in the source. For more information, see our HubSpot schema information.

Missing engagement columns or tables

If an engagement table is missing, first check whether Fivetran supports it for your HubSpot subscription. In HubSpot, find which HubSpot subscription your organization uses, then look for the corresponding engagement table in our HubSpot ERD.

If an engagement column is missing, look for it in the relevant engagement child table using the naming convention property_hs_<field>. If your schema change setting is set to Block all, you may need to manually include the column in your connection schema:

1. In Fivetran, go to your HubSpot connection page.
2. Select the Schema tab.
3. Find the relevant engagement child table.
4. Click the arrow icon to expand the table's columns.
5. Select the checkbox next to columns you want to include.
6. Click Save changes.

Missing association columns

Association tables store relationships between objects and do not include the objects' columns. We sync each object's fields to its own table instead. For more information, see our custom HubSpot objects documentation.

Missing deal_pipeline_stage_id data

We populate deal_pipeline_stage_id data into the DEAL_STAGE table instead of the DEAL_PROPERTY_HISTORY table. To include the DEAL_STAGE table in your connection schema:

1. In Fivetran, go to your HubSpot connection page.
2. Select the Schema tab.
3. Select the checkbox next to the DEAL_STAGE table.
4. Click Save changes.

Discontinued columns or tables

When we discontinue a column or table, we may either no longer populate it with data or populate it with null values. To find out whether a table or column was discontinued or replaced, see our HubSpot release notes.

Missing or delayed deletes

We use webhooks to capture deletes for the following tables:

• COMPANY
• CONTACT
• DEAL

Due to potential timeouts at the source or within the Webhook Processing System (WPS), it may take up to 30 minutes for these deletes to be reflected in the destination.