Specifies the batch operation mode for executing bulk data operations in Snowflake. This property determines whether the connection should use Binding API or Upload API based on the size of the data being processed.

Possible Values

Data Type

string

Default Value

"Auto"

Remarks

There are three accepted values: Auto (default), Binding, and Upload.

• Auto: Automatically selects the API based on the count of values. Uses Binding API if below the threshold defined by the session parameter client_binding_threshold. Otherwise, uses Upload API.
• Binding: Forces the use of the Binding API regardless of data size. Suitable for smaller data batches.
• Upload: Forces the use of the Upload API regardless of data size. Recommended for larger bulk uploads.

Forcing Binding or Upload can improve performance if you know the data size will always be small or large, respectively.