Load data from Blob Storage to Snowflake table

Rohit Kulkarni 676 Reputation points
2021-07-15T14:11:15.897+00:00

Hello Team

I am having csv file in the Azure Blob storage .I want to transfer the data from this csv file to SnowflakeTable in the lookup activty.

As Snowflake is in AWS.

But i am getting the error :

Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [22000] Failure using stage area. Cause: [Server failed to authenticate the request. Please refer to the information in the www-authenticate header. (Status Code: 401; Error Code: NoAuthenticationInformation)],Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [22000] Failure using stage area. Cause: [Server failed to authenticate the request. Please refer to the information in the www-authenticate header. (Status Code: 401; Error Code: NoAuthenticationInformation)],Source=Snowflake - Latest version supported by Snowflake: 2.21.1,'

Please advise.

115096-image.png

Regards
RK

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,488 questions
{count} votes