In an Azure Data Flow, use a DataSet and set dynamic value/paremeter of DataFlow into the parameter for the DataSet. Possible ?

Eric Franckx 40 Reputation points
2023-11-30T15:28:25.84+00:00

Hi,

I have a dataset to a Linked Service where I can set as parameter :

  • server name
  • Database Name
  • UserID
  • Password

and for the table aslo the schema and the table name:

User's image

In the Dataset I can preview the data : OK

So I would like to set some value into my Data Flow when connecting for source:

is this possible
User's image

as If I set fix value it works but seems not working when using Data Flow parameters

Maybe not possible or syntax is not correct ?

regards

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,181 questions
{count} votes

Accepted answer
  1. Suba Balaji 11,206 Reputation points
    2023-12-01T04:21:57.3266667+00:00

    Hi ,

    You want to use data flow param value for the data set params, am I right?

    What you are showing is debug setting. It is just used for debug session.

    If you want to use the same set of values as you pass to data flow param, go to pipeline, click on data flow activity, and then click settings tab.

    In the setting tab,.you will be seeing the dataset parameters where you need to pass the values 'gccs' for table name. This will be used during run time, by the data set references by the data flow.

    Hope that is clear. Please try and let us know.

    0 comments No comments

0 additional answers

Sort by: Most helpful