Parameterize Azure SQL Database dataset using Data flow activity

Raj D 581 Reputation points
2021-10-20T19:10:25.67+00:00

Greetings!!!

Could you please help me on how to parameterize Azure SQL Database dataset in Data flow. I am trying to move data from ADLS Gen 2 blob to an Azure SQL Database in an ADF pipeline using the Data flow activity. In the Dataset I'm able to parameterize it but not able to figure how to specify the parameters in the Data flow.

142187-adf-dataflow.jpg

142167-adf-dataset.jpg

Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,267 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,412 Reputation points Microsoft Employee
    2021-10-22T00:13:56.157+00:00

    Hi @Raj D ,

    Thanks for using Microsoft Q&A forum and posting your query.

    You can map the parameter values to your dataset by clicking on the Dataflow activity in your pipeline and under Settings you will see the source parameters populated.

    142651-image.png

    In the above example I'm mapping pipeline parameters to data flow source dataset parameters.

    Hope this info helps. Do let us know if you have further query.

    ----------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful