Specifies whether the provider expands association tables to include one table per object-to-object relationship.

Data Type

bool

Default Value

false

Remarks

This property controls how association data is represented in the schema. It is valid in the HubSpotV3 and HubSpotV4 schemas.

When set to false, the connector exposes one associations table per object type. For example:

• DealAssociations
• CompanyAssociations
• ContactAssociations

Each table returns the IDs of the objects associated with that type. For example, DealAssociations returns the IDs of objects associated with each deal.

When set to true, the connector expands the schema to include a separate associations table for each pair of related object types. For example:

• CompaniesToContactsAssociations
• ContactsToDealsAssociations
• DealsToLineItemsAssociations

These tables return pairs of IDs showing the relationships between the two object types.

Performance Considerations

Enabling this property increases the number of tables in the schema. This may improve clarity and querying flexibility when working with complex inter-object relationships, but could impact metadata loading time, especially in tools that introspect the full schema.