Use ADF Pipeline RUN ID as table name

Question

I'm trying to use ADF pipeline RUN ID as table name. On running the pipeline, I see the following error:

EDIT

table name contains invalid characters

Could you please suggest a workaround on this issue? Thank you!

Can you demonstrate why you can't use the RunId as a table name? Is it an ADF problem or a SQL Server problem? SQL requires table names with special characters to be enclosed in back quotes (not sure ADF does this) learn.microsoft.com/en-us/sql/odbc/microsoft/… — Joel Cochran
– Joel Cochran, Commented May 28, 2020 at 13:35
It was mentioned here: stackoverflow.com/questions/62056682/… — user989988
– user989988, Commented May 28, 2020 at 16:28
Sorry, I misread it as SQL table instead of Storage table. I'm maybe still not following why you can't use it: won't @pipeline().RunId will give you the value? — Joel Cochran
– Joel Cochran, Commented May 28, 2020 at 16:46
Answer in that stack overflow says 'But we can not provide the RUN ID of pipeline run as the table name in the table storage and copy data from blob to that table in table storage." — user989988
– user989988, Commented May 28, 2020 at 17:37
I guess I'm just failing to see why that is the case. If you can capture it as a Variable value, then it seems to me you could use it as a DataSet parameter value. — Joel Cochran
– Joel Cochran, Commented May 28, 2020 at 17:53

Jason Welch · Accepted Answer · 2020-05-29 00:19:22Z

From here the name has to be alpha and start with a letter so how about this dynamic content:

tbl@{replace(pipeline().RunId,'-','')}

1 Answer 1