Allow specifying the binding type for the Date, Time and Timestamp_* type.

Syntax

Connect-Snowflake -BindingType string

Possible Values

Data Type

cstr

Default Value

"DEFAULT"

Remarks

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

• DEFAULT: Uses the binding type DATE for the Date type, TIME for the Time type, and TIMESTAMP_* for the Timestamp_* type. 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, if the insert query is executed using the Upload API, this session parameter does not apply. As a result, timestamp values may vary when inserting different quantities of records.
• TEXT: Uses the binding type TEXT for Date, Time, and Timestamp_* types. This option ensures consistent timestamp values across both the Binding API and the Upload API, regardless of the number of inserted records.