Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,643 questions
Load data from Blob Storage to Snowflake table
Rohit Kulkarni
656
Reputation points
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
{count} votes
-
ShaikMaheer-MSFT 29,721 Reputation points Microsoft Employee2021-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.
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
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:
Hi @Rohit Kulkarni ,
Did you get chance to share above requested details?
Hi @Rohit Kulkarni ,
Following up to see if you get chance to share above requested details?
Sign in to comment