Snowflake and Data Factory Error because of regions

634 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
Ryan Goodman 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.