Modify global parameter ADF pipeline

Question

How can I modify the value of a global parameter declared in a pipeline of an ADF?

Let's say I need to check whether or not a file in a ADLS exists. I declare a boolean global parameter, but according to my logic inside a U-SQL activity I need to modify its value. How can I do that?

Thanks!!!

Answer 1

U-SQL's script parameter model only provides input parameters and no output parameters. If you want to communicate something back, you currently have to do this via a file. E.g., you write the file in the script and then use a Powershell activity to look at the file to set the ADF parameter (I assume that Data Factory has that option).