Azure data factory snowflake connector v2 connection issues

Question

I'm working on an azure datafactory system that loads data into Snowflake using the existing / V1 Snowflake connector

I saw an alert on the data factory portal warning that the connector is being retired and advising to use the Snowflake connector V2.

I've tried creating a new linked service with the new Snowflake connector and testing it using a script task with a simple select task but i'm getting the following error.

Message=Failed to open the database connection.,Source=Microsoft.DataTransfer.Connectors.GenericAdoNet,''Type=Apache.Arrow.Adbc.AdbcException,

Message=[Snowflake] timeout after 5m0s and 8 retries. HTTP Status: 513. Hanging?,Source=Apache.Arrow.Adbc,''

Does anyone know what the error message means or possible causes.

The same SQL executes correctly in a script task using the v1 connector

Answer 1

Hello SteveAtMSLearning

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Issue:

• Azure data factory snowflake connector v2 connection issues

Error Message:

• Message=Failed to open the database connection.,Source=Microsoft.DataTransfer.Connectors.GenericAdoNet,''Type=Apache.Arrow.Adbc.AdbcException,

Message=[Snowflake] timeout after 5m0s and 8 retries. HTTP Status: 513. Hanging?,Source=Apache.Arrow.Adbc,''

Solution:

• It turns out the account name is not the account name in the snowflake portal user profile page, its actually based on the url that the portal uses Eg for portal url  https app.snowflake.com/myorganisation/myuser The account name is myorganisation-myuser not myuser as shown in the profile page.

If you have any other questions, please let me know.

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.