azure data factory connection with snow flake

Question

I created a azure datafactory and trying to create a snowflake link. I provided all required details for this connection but my connection is getting timeout.

Answer 1

Hi @Gupta, Sumit K You're encountering a timeout error when attempting to create a linked service between Azure Data Factory (ADF) and Snowflake, despite entering all the required connection details.

Here are a few things you can check to help resolve this:

Network Configuration: If your Snowflake environment is behind a firewall or deployed in a private network (such as an Azure VNet or on-prem setup), you may need to:

• Use a Self-hosted Integration Runtime (IR) instead of the default Azure IR.
• Ensure the IR host machine can reach *.snowflakecomputing.com on port 443.
• Confirm Snowflake’s network policy or firewall allows connections from Azure or your Self-hosted IR IP.

Test network connectivity from Self-hosted IR:

Test-NetConnection <account>.snowflakecomputing.com -Port 443

Integration Runtime Whitelisting: If you're using the Azure Integration Runtime, ensure Snowflake firewall settings allow outbound traffic from Azure's IP ranges.

• Snowflake environments secured by network policies or firewalls must explicitly allow Azure’s outbound IPs.
• IPs vary by region and runtime — refer to the official documentation to get the current list.

Authentication & Permissions: Ensure you're using a supported authentication method, and all credentials are correctly entered:

Username/password or key pair authentication.

The user should have:

• USAGE on database and schema
• SELECT, INSERT, etc., on tables/views
• CREATE STAGE if applicable

Connection Details Validation: Ensure that connection values match Snowflake's expected format:

• Account: Should be xy12345.region.azure or xy12345.snowflakecomputing.com depending on deployment
• Warehouse, Database, Schema: Must exist and be accessible
• Region: Must be specified exactly as in Snowflake console

Use the "Test Connection" Feature

• In Azure Data Factory, use the "Test connection" button on the linked service setup page.
• If the timeout persists and the error message includes additional detail, it can help narrow the issue.

---

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.