question

RajD-9527 avatar image
0 Votes"
RajD-9527 asked RajD-9527 commented

Parameterize Azure SQL Database dataset using Data flow activity

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
adf-dataflow.jpg (28.4 KiB)
adf-dataset.jpg (27.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered RajD-9527 commented

Hi @RajD-9527 ,

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


image.png (46.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KranthiPakala-MSFT , Thanks very much for your response.

0 Votes 0 ·