Forum Discussion

Chaitanya_Koneru's avatar
Chaitanya_Koneru
Copper Contributor
Aug 26, 2021

Snowflake as Sink is not working in ADF

We are copying data from on premise SQL server to Snowflake hosted in AWS(west-us2 region). As there is no direct option we had created a Azure BLOB (in west-us2 region) staging area  to use it. However , when we execute the Pipeline with Copy Activity, it is throwing below Error 

"ErrorCode=SnowflakeUnsupportedCouldPlatformForImport,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Snowflake only support the account hosted in azure platform while as sink connector, please make sure your account is hosted in azure, current region and platform is 'AWS_US_WEST_2',Source=Microsoft.DataTransfer.ClientLibrary,'"

 

Note: We saw the file is generating it in BLOB. So came to conclusion that the issue is at Sink side.

 

Azure Data Factory
  • Chaitanya_Koneru's avatar
    Chaitanya_Koneru
    Copper Contributor
    Sep 06, 2021
    Update : to make this thread helpful for the others. We had raised a ticket to Microsoft on the same and they confirmed that ADF is not supporting to push the data from Azure BLOB to Snowflake hosted in AWS. We didn't see any documentation around this. So we had asked them to update this in their ADF Snowflake connector documentation.
    • MadhanKS's avatar
      MadhanKS
      Copper Contributor
      Nov 09, 2021
      Did you get any solutions?. I am also facing the same issue
      • Chaitanya_Koneru's avatar
        Chaitanya_Koneru
        Copper Contributor
        Nov 10, 2021
        No, mine is different. As my Source and Target is hosted both in the Snowflake we handled it by writing the complete logic in Snowflake Stored procedures and called them in ADF using Lookup activity. However the above requirement is for existing data migration from On premise SQL server to Snowflake. As this is a one time task , we handled it in a different way (which is outside of ADF).

Resources