Can Azure data factory use Snowflake hosted in AWS as sink?

Question

Can Azure data factory use Snowflake hosted in AWS as sink?

kbeatty 1

Getting this error when trying to use Snowflake hosted on AWS as sink in copy data activity:

Operation on target DataFactory_Test_send_log failed: 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_EAST_1',Source=Microsoft.DataTransfer.ClientLibrary,'

Please confirm data can be sinked to Snowflake on AWS. Thanks.

1 answer

Your answer

Answer 1

Takahito Iwasa 4,851 MVP Volunteer Moderator

Hi, @kbeatty

Only Azure is supported when specifying Snowflake for the sink.
It is described in the following documents.

https://learn.microsoft.com/en-us/azure/data-factory/connector-snowflake?tabs=data-factory

Copy data to Snowflake that takes advantage of Snowflake's COPY into [table] command to achieve the best performance. It supports Snowflake on Azure.

You can also use Snowflake on AWS as a source rather than a sink.

kbeatty 1 Reputation point

2022-09-13T19:48:10.513+00:00

Thanks @Takahito Iwasa . Disappointing. Any reason why? Other ETL tools allow both read and write to Snowflake hosted on AWS.
AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator

2022-10-07T08:02:52.193+00:00

Hi @kbeatty ,

Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.

Additionally, Appreciate if you could share the feedback on our Azure Data Factory feedback channel, which would be open for the user community to upvote & comment on. This allows our product team to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Share via

Can Azure data factory use Snowflake hosted in AWS as sink?

1 answer

Your answer