Specifies the mechanism the provider uses when it performs BulkInsert operations.

Possible Values

Data Type

string

Default Value

"COPY"

Remarks

Choose the mode that best fits your environment, permissions, and performance goals:

• COPY: Stages data in an external storage account, then executes COPY INTO to load the table. Fastest throughput, but requires valid StorageAccountLocation and AzureSASToken values. Supports INSERT statements only.
• BCP: Streams data directly to Azure Synapse over the Bulk Copy Protocol. This is useful when you can’t use external storage yet still need high-speed, INSERT-only loading.
• STANDARD Executes regular INSERT, UPDATE, and DELETE statements in batches, with no staging or BCP. Use when you need mixed DML or lack permissions for COPY/BCP.

This property is helpful when you need to trade off speed, network constraints, and security policies: picking the right mode can cut minutes—or even hours—from large loads while letting you work within the permissions and infrastructure you actually control.