Missing Columns, Tables, or Values

Issue

Columns, tables, or values are missing in the destination.

Environment

Connector: HubSpot

Answer

Missing columns or tables

The HubSpot connector doesn't support the creation of empty tables and columns. As a result, we will not sync columns or tables to the destination if there is no applicable data in the source. See our HubSpot sync strategy for more information.

Missing engagement columns and tables

If you are missing an engagement table, check if we support it by doing the following:

1. In HubSpot, find which HubSpot subscription your organization uses.
2. Look for the table associated with your subscription in our HubSpot ERD.

We sync engagement columns to the relevant engagement child table with the name convention property_hs_<field>. If you can't find an engagement column, go to the Schema tab in your HubSpot connector dashboard and click Schema settings. If your schema change setting is set to Block all, you must select each applicable column individually from the schema config.

Missing association columns

Association tables create associations between objects but don't contain columns related to the object. We will sync an object's columns to the relevant object's table. See our custom objects documentation for more information.

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.

Missing records or null values

When we deprecate a column or table, we may either no longer populate it with data or populate it with null values. See our Hubspot release notes for more information on deprecated tables and columns.