Azure SQL DB to Snowflake

Rohit Kulkarni 656 Reputation points

Hello Team,

I am trying to upload the data from Azure SQL DB Table to Snowflake db table.As snowflake is in AWS and we are creating the pipeline in azure data factory.

Please refer the below error :



Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,669 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 37,886 Reputation points

    Error message clearly states that Snowflake is hosted on AWS and not on Azure so this is not supported. By default the Azure Integration Runtime thinks that it is hosted on Azure but doesn't fine it

    You can upvote similar feedback posted here -

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.

  2. KranthiPakala-MSFT 35,522 Reputation points Microsoft Employee

    Hi @Rohit Kulkarni ,

    Thanks for using Microsoft Q&A forum and posting your query.

    As anonymous userChaudhari called out, ADF native Snowflake connector doesn't support Snowflake hosted in AWS. It supports Snowflake on Azure only. This has been called out in the public documentation under supported capabilities section.


    Workaround: As the ADF Snowflake native connector doesn't fit your requirement you could try using ADF ODBC connector instead, as Snowflake supports ODBC -

    I would highly recommend you to please upvote and comment on the feedback in ADF uservoice forum, which would help to increase the priority of feature request.

    Hope this info helps.


    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.