question

ShubhamBartakke-8947 avatar image
0 Votes"
ShubhamBartakke-8947 asked HimanshuSinha-MSFT commented

How to pass Wild Card File Name in ADF Databricks Activity

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 @concat(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 @concat(item().TABLE_NAME,'*') ----


but its gives as A*.csv not found

azure-data-factoryazure-databricks
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @shubhambartakke-8947,

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

0 Votes 0 ·

Hi @shubhambartakke-8947 Following up as I haven't heard back.

Thanks
Saurabh

0 Votes 0 ·

Hello @ShubhamBartakke-8947 ,
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

0 Votes 0 ·

0 Answers