question

RevJr-4064 avatar image
0 Votes"
RevJr-4064 asked ShaikMaheer-MSFT commented

403 Error while coping files to snowflake from Blob.

Hi Team I am getting the below error, I have tried the role assignment, using self-hosted IR, even changed the pipeline from scratch still I am getting the same error,kindly help me to fix it. I also look forward for the root cause.

Operation on target Copy data Blob to Snowflake failed: Failure happened on 'Sink' side. ErrorCode=FileForbidden,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error occurred when trying to upload a blob, detailed message: username.txt,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.WindowsAzure.Storage.StorageException,Message=The remote server returned an error: (403) Forbidden.,Source=Microsoft.WindowsAzure.Storage,StorageExtendedMessage=Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.
RequestId:c9a185e5-201e-006b-2d63-b42f03000000
Time:2021-09-28T12:20:11.5702219Z,,''Type=System.Net.WebException,Message=The remote server returned an error: (403) Forbidden.,Source=Microsoft.WindowsAzure.Storage,'

azure-data-factoryazure-storage-accounts
· 2
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 @RevJr-4064 ,

Thank you for posting query here.

Is this error coming at linked service level while testing connection? If yes, you authentication information may be incorrect or credentials what you are using may not has access to authenticate.

Could you please share more details on where exactly error happening and what kind of authentication is getting used? Is all required permission granted? Thank you.

0 Votes 0 ·

Hi @RevJr-4064 ,

Following up to see you get chance to see above comment and share details?

0 Votes 0 ·

0 Answers