Specifies the binding type used for handling Date, Time, and Timestamp_* data types during data insertion operations. This property ensures consistent handling of temporal data when using different APIs for data ingestion.

Possible Values

Data Type

string

Default Value

"DEFAULT"

Remarks

There are two kinds of binding types: DEFAULT and TEXT.

• DEFAULT: Uses native binding types: DATE for Date, TIME for Time, and TIMESTAMP_* for Timestamp. By default, the driver selects either the Binding API or Upload API based on the number of records, unless BatchMode is specified.

  The behavior for TIMESTAMP_* types is determined by the session parameter CLIENT_TIMESTAMP_TYPE_MAPPING. However, when using the Upload API, this session parameter does not apply, potentially causing inconsistent timestamp values when inserting different quantities of records.

• TEXT: Uses TEXT binding for Date, Time, and Timestamp_* types. This ensures consistent timestamp handling across both the Binding API and Upload API, regardless of the number of records being inserted.

  If you need consistent timestamp handling across Binding API and Upload API, use BindingType=TEXT.