Loading data from ADLS Gen2 to Snowflake

Visitor

trying to load a csv file using Azure data factory Copy Activity and getting the following error, was able to move the same file from ADLS Gen2 to Snowflake using Data flow activity using the same linked services though , any inputs/suggestions are much appreciated

Source file: sample_data.csv


getting the following error while using copy activity in ADF, but using the same connection I am able to load data in snwofalke using Dataflow activity
Failure happened on 'Sink' side. ErrorCode=FileForbidden,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error occurred when trying to upload a blob, detailed message: sample_data.txt,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.WindowsAzure.Storage.StorageException,Message=The remote server returned an error: (403) Forbidden.,Source=Microsoft.WindowsAzure.Storage,StorageExtendedMessage=This request is not authorized to perform this operation using this permission. RequestId:75278c45-501e-0038-5c7f-a95446000000 Time:2021-09-14T15:47:26.3271187Z,,''Type=System.Net.WebException,Message=The remote server returned an error: (403) Forbidden.,Source=Microsoft.WindowsAzure.Storage,'
Edited
0 Replies