Snowflake Connection Fails in Azure Data Factory (ADF) Due to Authentication Limitation

Question

Why is my Snowflake connection failing in Azure Data Factory (ADF) when trying to connect, and how can I resolve the authentication issue?

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

The Snowflake connection in Azure Data Factory (ADF) is failing due to an authentication method limitation. Currently, ADF uses the "COPY INTO" command for Snowflake, which only supports SAS URL for blob authentication. This limitation means that you cannot use a service principal for authentication in this scenario. An internal ticket was raised to confirm this limitation and explore possible alternatives.

To resolve this issue, you can use a private link to secure storage in Snowflake. This setup ensures that your data remains secure while still adhering to the current authentication requirements.

For more information on setting up Snowflake connectivity in ADF, you can refer to the official documentation here: Snowflake Connector for ADF.

Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.

Please do not forget to "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.