1

I have a request to select the values from a sql table and pass it to adf pipeline example:

sql table-->abc with columns(col1,col2,col3,col4,col5)

I need to pass the col1 to col5 values as input to a pipeline abc.

how can we do that please suggest or if it is feasible solution.

Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
batman_special
  • 115
  • 1
  • 2
  • 10

1 Answers1

0

You can use the below flow to achieve the same:

  1. Lookup activity: this would include your select query
  2. After lookup activity >>> Execute pipeline activity wherein you would pass the lookup activity output values as input to the pipeline @activity('LookupActivityNm').output.value[0].col1 @activity('LookupActivityNm').output.value[0].col2
Nandan
  • 3,939
  • 2
  • 8
  • 21