Azure data factory snowflake connector v2 connection issues

SteveAtMSLearning 20 Reputation points
2024-08-28T11:03:24.9566667+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,566 questions
Accepted answer
  1. Bhargava-MSFT 30,816 Reputation points Microsoft Employee
    2024-09-04T11:56:15.4333333+00:00

    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.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.