question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked ShaikMaheer-MSFT commented

Load data from Blob Storage to Snowflake table

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
image.png (17.1 KiB)
· 5
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 @RohitKulkarni-6062 ,

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.



0 Votes 0 ·

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

0 Votes 0 ·

Hi @RohitKulkarni-6062 ,

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?

0 Votes 0 ·

Hi @RohitKulkarni-6062 ,

Did you get chance to share above requested details?

0 Votes 0 ·

Hi @RohitKulkarni-6062 ,

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

0 Votes 0 ·

0 Answers