TDV Adapter for Azure Synapse

Build 21.0.8137

BatchMode

The Batch Mode of Azure Synapse bulkInsert.

Possible Values

BCP, COPY, STANDARD

Data Type

string

Default Value

"COPY"

Remarks

COPY utilizes an external storage account to load data into and then copy into your AzureSynapse table. You will also need to set the StorageAccountLocation and the AzureSASToken, which only supports INSERT statement. BCP transfers data to AzureSynapse directly with BulkLoadBCP protocol through the TCP communication between client and server, which only supports INSERT statements. STANDARD uses standard INSERT, UPDATE and DELETE statements for batch operations.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137