This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 :
Regards
Rohit
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
Hello Vaibhav,
There must be some workaround right to connect to Snowflake from Azure.
The link mentioned above it doesn't provide any information
Please advise any workaround.
Regards
RK
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 - https://docs.snowflake.com/en/user-guide/odbc-parameters.html
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.
Hi @Rohit Kulkarni ,
Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Hi @Rohit Kulkarni ,
We still have not heard back from you. Just wanted to check if the above suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.