Specifies a comma-separated list that defines custom column sizes for specific fields.

Data Type

string

Default Value

""

Remarks

Use this property to override the default column sizes for fields returned by the connector in the HubSpot schema. This is useful when certain fields are known to exceed the default size and require a larger buffer for accurate retrieval.

Accepted formats include:

• TableName.ColumnName=Size
• ColumnName=Size

For example: Table1.Col1=4000,Table1.Col2=5000,Col1=13

In this example:

• Col1 in Table1 is set to 4000.
• Col2 in Table1 is set to 5000.
• Col1 in all other tables is set to 13.

When both a fully qualified (TableName.ColumnName) and unqualified (ColumnName) entry exist, the fully qualified value takes precedence.

Note: This property is valid only for HubSpot Object tables like: Contacts, Companies, Deals, etc.

Performance Considerations

Setting unnecessarily large column sizes may increase memory usage and reduce performance in client applications, especially when working with large datasets. For best results, size fields only when the default length is known to be insufficient.