403 Error while coping files to snowflake from Blob.

RevJr 1

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,'

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-09-30T09:54:34.593+00:00

Hi @RevJr ,

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.
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-10-05T09:08:03.72+00:00

Hi @RevJr ,

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