Skip to main content

Copy Method

Controls the copy method used for ADF Copy Activities. Accepted values are BulkInsert (default) and PolyBase.

For Snowflake targets, BulkInsert lands data as files in Azure Blob Storage which Snowflake then reads via COPY INTO — it does not perform direct row-by-row inserts into Snowflake. PolyBase is only relevant for Azure Synapse (SQL DW) targets, where it uses PolyBase external tables to load data from blob storage into the data warehouse. Select the appropriate method based on your target platform and loading architecture.

Notes:

  • This setting is part of the Azure Copy settings category.
  • The default value for this setting is BulkInsert.