How to pass Wild Card File Name in ADF Databricks Activity

Shubham Bartakke 1

HI ,

I am working in for each Activity in the ADF , in For each we have copy activity and then we pass the table name to databricks as parameter .
Copy activity supports wild card paths @markus.bohland@hotmail.de (item().TABLE_NAME,'*')---- its picking correct names like -
A 1st jan2021.csv
A 2ndjan2021.csv

Now we want the same data to passin databricks as parameter @markus.bohland@hotmail.de (item().TABLE_NAME,'*') ----

but its gives as A*.csv not found

Saurabh Sharma 23,801 Reputation points Microsoft Employee

2021-04-26T23:31:29.237+00:00

Hi @Shubham Bartakke ,

Thanks for using Microsoft Q&A !!

Can you please share more details like what copy activity is doing and how are you getting the table names ? Also, could you please share where are you getting errors. Are you able to get the expected values inside ForEach loop before passing it to Notebook ? Code snippets/screenshots will be also helpful.

Thanks
Saurabh
Saurabh Sharma 23,801 Reputation points Microsoft Employee

2021-04-29T00:11:40.793+00:00

Hi @Shubham Bartakke Following up as I haven't heard back.

Thanks
Saurabh
HimanshuSinha-msft 19,471 Reputation points Microsoft Employee

2021-05-03T19:15:23.323+00:00

Hello @Shubham Bartakke ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

Share via

How to pass Wild Card File Name in ADF Databricks Activity

Your answer