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 ?
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