How to write Dynamic query in Azure Bulk data pool?

Vinay Raghuwanshi 1 Reputation point
2020-08-25T10:48:08.257+00:00

I want to write Dynamic query in Azure SQL Bulk data load.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,599 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,601 Reputation points
    2020-08-25T11:05:49.293+00:00

    You can follow below tutorials where dynamic SQL Queries are formed and used in Copy activity.

    Step 6 in https://learn.microsoft.com/en-us/azure/data-factory/tutorial-bulk-copy-portal#create-the-pipeline-iterateandcopysqltables

    Step 21 in https://learn.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-portal#create-a-pipeline

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.
    0 comments