none
Passing&Accessing parameters to USQL script

    Question

  • Hi Team

    I am trying to create a pipeline.I have followed the below steps.

    Step 1: I have created a lookup activity which has the input as store procedure from Azure SQL database. The stored procedure will return three columns.I have given the three columns in the schema of azure SQL database

    Step 2:I have created a For each activity and connected it to the lookup activity .

    Step 3:I have created a copy activity and if activity inside the foreach.

    Here comes the situation,After doing all the above steps,  .In the U-SQL script i need to insert the three columns dynamically .

    Please let me know where to create the parameters and how to insert the parameters dynamically using U-SQL script.

    Thanks

    Shankar


    shankar

    Monday, August 20, 2018 10:52 AM

All replies

  • Hi Shankar,

    If I understand correctly, the look up activity returns three columns, so you just need to chain the U-SQL activity after copy activity, and pass the '@activity('Lookup1').output.value' to parameter in U-SQL. Please see the pic below:

    Thanks.

    Tuesday, August 21, 2018 1:50 AM