Load data from Blob Storage to Snowflake table

Rohit Kulkarni 676

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.

Regards
RK

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-07-16T11:42:05.947+00:00
Hi @Rohit Kulkarni ,

Thank you for posting query here. Could you please help on below clarifications to understand issue and help on resolution.

What your Source and Sink types in Copy activity?

What is the dataset type which you selected in lookup activity? Is linked service test connection is getting successful in it?

Could you please share all configuration details of your lookup activity in json format or using screenshots?

Thank you.
Rohit Kulkarni 676 Reputation points

2021-07-17T07:45:37.903+00:00

Hello Maheer,

Please refer details:

Copy Activity:

Source : Azure sql db

Target DB:Azure Blob Storage

Look Activty

Dataset : Snowflake tables

As snowflake is in AWS .

Regards
RK
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-07-19T11:10:14.313+00:00
Hi @Rohit Kulkarni ,

Thank you for response and sharing details. But Still We are missing details related to look activity and linked service test connection status inside lookup activity dataset.

It would be great if you can help on below:

Look up activity entire configuration details or lookup activity entire json?

Is linked service for your Snowflake(inside look up activity) getting success?
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-07-23T05:27:54.12+00:00

Hi @Rohit Kulkarni ,

Did you get chance to share above requested details?
ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2021-07-26T05:30:56.547+00:00

Hi @Rohit Kulkarni ,

Following up to see if you get chance to share above requested details?