pass multiple dynamic parameters to U-SQL script via data factory

Question

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?

Michael Rys · Accepted Answer · 2018-03-07 18:22:39Z

2

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.

answered Mar 7, 2018 at 18:22

Michael Rys

6,68417 silver badges23 bronze badges

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

Comments

Miguel Domingues · Accepted Answer · 2018-03-07 10:58:29Z

1

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

answered Mar 7, 2018 at 10:58

Miguel Domingues

4383 silver badges11 bronze badges

Collectives™ on Stack Overflow

pass multiple dynamic parameters to U-SQL script via data factory

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related