Snowflake as Sink is not working in ADF

%3CLINGO-SUB%20id%3D%22lingo-sub-2687660%22%20slang%3D%22en-US%22%3ESnowflake%20as%20Sink%20is%20not%20working%20in%20ADF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2687660%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20copying%20data%20from%20on%20premise%20SQL%20server%20to%20Snowflake%20hosted%20in%20AWS(west-us2%20region).%20As%20there%20is%20no%20direct%20option%20we%20had%20created%20a%20Azure%20BLOB%20(in%20west-us2%20region)%20staging%20area%26nbsp%3B%20to%20use%20it.%20However%20%2C%20when%20we%20execute%20the%20Pipeline%20with%20Copy%20Activity%2C%20it%20is%20throwing%20below%20Error%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%22ErrorCode%3DSnowflakeUnsupportedCouldPlatformForImport%2C'Type%3DMicrosoft.DataTransfer.Common.Shared.HybridDeliveryException%2CMessage%3DSnowflake%20only%20support%20the%20account%20hosted%20in%20azure%20platform%20while%20as%20sink%20connector%2C%20please%20make%20sure%20your%20account%20is%20hosted%20in%20azure%2C%20current%20region%20and%20platform%20is%20'AWS_US_WEST_2'%2CSource%3DMicrosoft.DataTransfer.ClientLibrary%2C'%3C%2FSTRONG%3E%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3A%20We%20saw%20the%20file%20is%20generating%20it%20in%20BLOB.%20So%20came%20to%20conclusion%20that%20the%20issue%20is%20at%20Sink%20side.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2687660%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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.

 

1 Reply
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.