How to write Dynamic query in Azure Bulk data pool?

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

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.
6,245 questions
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2020-08-25T11:05:49.293+00:00
    Vaibhav Chaudhari 37,751 Reputation points

    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

    No comments