Azure Data Factory U-SQL activity dynamic parameter

Question

Lets suppose I have a U-SQL script which get executed every one hour from ADF pipeline. I have mssql database which contains config table. Is there any way to read a config from database and pass it to U-SQL script? In ADF docs i couldn't find any way of doing it. Only SliceStart, SliceEnd, but what if my parameter is type of GUID ?

ShirleyWang-MSFT · Accepted Answer · 2018-01-10 10:14:18Z

2

You can achieve this in ADF V2 (currently in Public Preview) using the Lookup activity. The lookup activity can pass the lookup results to the subsequent activity (in your case U-SQL activity).

https://learn.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity

answered Jan 10, 2018 at 10:14

ShirleyWang-MSFT

2861 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nario Over a year ago

can you please help me with this ? stackoverflow.com/questions/49138273/…

Collectives™ on Stack Overflow

Azure Data Factory U-SQL activity dynamic parameter

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related