data factory copy error

sakuraime 2,321

I have a parquet file in blob ADLS GEN2 , I have a synapse analytics dedicated pool . I have a ADF copy activity where source is the parquet while sink is the synapse .

the copy activity use polybase . and there is a error

and I was trying to build external table directly on synapse analytics which has no issue. (same path).

while I also found that during the activity run , it create a credential like in the following

CREATE DATABASE SCOPED CREDENTIAL [ADFCopyGeneratedCredential_9eafecb1-949c-4c55-99d5-48ecab22eb4a] WITH IDENTITY = 'ADF', Secret = '***'

what's ADF?? I can't find it in my AAD.

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-05-03T19:42:59.017+00:00

Hi @sakuraime ,

Thanks for reaching out. To better assist on this issue could you please provide us the failed activity runID, failed pipeline runID as well as copy paste the complete error message by masking sensitive info like connection string/passwords. And also I see that you have mentioned source format is Parquet, but what is the source, is it a storage/Gen2 or something else? An d my understanding is that your sink is Synapse dedicated pool. Please correct if I misunderstand your requirement.

Thank you
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-05-04T21:30:24.483+00:00

Hi @sakuraime ,

Just checking to see if you have got a chance to provide few additional details as requested in my previous comment.

Thanks
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2021-05-05T15:20:05.417+00:00

Hi @sakuraime ,

We still have not heard back from you. Just wanted to check if you are still facing the issue or need assistance on this? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue. Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
sakuraime 2,321 Reputation points

2021-05-06T10:24:05.827+00:00

I will need to reproduce again . let me get back to you .