Specifies how the provider represents numeric fields detected as number types in HubSpot.

Possible Values

Data Type

string

Default Value

"DECIMAL"

Remarks

HubSpot reports all numeric fields (integers, floats, and decimals) using a generic number type. Because of this, the driver cannot reliably infer the exact numeric type for each field.

Use this property to control how those fields are reported in the schema. Valid values include:

• DOUBLE: Numeric fields are reported using the DOUBLE type, suitable for floating-point math or large datasets where precision is less critical.
• DECIMAL: Numeric fields are reported using the DECIMAL type for high-precision use cases.
• STRING: Numeric fields are reported as STRING values. Use this when numeric precision or formatting may vary or when working with systems that do not natively support numeric types.

Performance Considerations

Choosing DOUBLE may improve performance for mathematical operations, while DECIMAL offers better precision. Setting the value to STRING avoids rounding or precision issues altogether but may impact downstream numerical calculations.

Note: This property is only applicable when using the HubSpotV3 schema.