Snowflake and Data Factory Error because of regions

607 Views Asked by At

Im getting an error when running Data Factory to load data into Snowflake:

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 '',Source=Microsoft.DataTransfer.ClientLibrary,'

Does the azure blob storage (staging area for copy command) needs to be in the same region as where snowflake was provision?

1

There are 1 best solutions below

0
On

In my case going to the warehouse you have configured and enabling "Auto Resume" solved the issue for me. Hope this helps someone running into this same issue.