pass multiple dynamic parameters to U-SQL script v

问题:

currently I can pass one parameter to u-sql script in data factory workflow. and with that parameter i can apply some pattern to generate files paths. is there any way to pass collection of datetimes parameters to u-sql and apply pattern to generate file paths?

回答1:

You can pass multiple parameters. U-SQL also allows parameters of type SqlArray<>. I am not sure though if ADF supports passing in such typed values. I think the PowerShell APIs do allow it.

I assume that passing the values as a file will not work, since you will not get compile time partition elimination with it.

回答2:

Pass a Json parameter. Then handle it with u-sql.