ODBC Driver for Azure Synapse

Build 25.0.9434

StorageAccountLocation

Specifies the Azure Blob Storage container that the provider uses to stage data files when the BatchMode property is set to COPY.

Data Type

string

Default Value

""

Remarks

If this property is left blank and BatchMode is set to COPY, the driver cannot stage files and the load fails. When you supply a value, the driver uploads CSV/Parquet files to the specified container and then executes a COPY INTO statement that reads directly from those files.

Provide the full HTTPS URL. For example: https://myaccount.blob.core.windows.net/myblobcontainer. In this example, "myaccount" is your Azure Blob account name and "myblobcontainer" is the container you want to use.

This property is useful when you want the highest-throughput loads available in COPY mode or when you need to separate staging storage from the driver workspace’s default data lake for security or cost-allocation reasons.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434