Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,335 questions
ADF Pipeline Issue from Snowflake to Azure SQL data copy
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 23%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
PK PK
0
Reputation points
Hi Team,
Im trying to create function in Azure SQL using ADF Pipeline,Some times My pipeline is getting success and sometimes its failing with below error.Please provide me solution for the below issue.
operation on target ITERATE_TABLES_LOAD failed: Activity failed because an inner activity failed; Inner activity name: PL_LOAD_SNOWFLAKE_AZURESQL, Error: Operation on target ACT_FUNCITON_CREATE failed: Failed to execute script. Exception: ''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'myserver', Database: 'mydb', User: 'myuser'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.,Source=Microsoft.DataTransfer.Connectors.MSSQL,''Type=Microsoft.Data.SqlClient.SqlException,Message=Server provided routing information, but timeout already expired.,Source=Framework Microsoft SqlClient Data Provider''
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 99%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
J N S S Kasyap 860 Reputation points Microsoft External Staff2025-03-11T01:21:25.94+00:00 Hi @PK PK
Your ADF pipeline sometimes succeeds but intermittently fails when copying data from Snowflake to Azure SQL and executing a function. The error message suggests that the connection to Azure SQL is timing out or being blocked.
Possible reasons and solutions:
Azure SQL firewall rules may be blocking ADF’s Integration Runtime (IR), causing intermittent connection failures. To resolve this, go to
Azure SQL Database → Networking → Firewall Settings, add ADF’sIR outbound IP addresses, and enable “Allow Azure services and resources to access this server” if applicable.Intermittent failures may occur due to network fluctuations in
Self-Hosted IRor regional latency inAzure IR. To fix this, restartSelf-Hosted IRif needed, consider switching to a different region forAzure IR, and ensure stable internet connectivity to Azure SQL.Azure SQL may be too slow to respond due to network latency or a long-running function/query, causing a timeout error. To fix this, increase the
Connection Timeoutin theAzure SQL Linked Servicein ADF, optimize the function if it takes too long, and manually test it in SQL to identify performance issues.High CPU, memory, or DTU usage in Azure SQL can lead to performance issues and intermittent timeouts. To resolve this, regularly monitor database performance, scale up the database if resource utilization remains high, and optimize query execution plans to improve efficiency.
Please refer the useful links :
https://learn.microsoft.com/en-us/answers/questions/336067/azure-data-factory-azure-sql-connectivity-error-ch
https://stackoverflow.com/questions/78188496/unable-to-connect-to-azure-sql-from-azure-data-factory
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.
Thank you.
-
J N S S Kasyap 860 Reputation points Microsoft External Staff
2025-03-11T18:09:00.91+00:00 @PK PK
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help. -
J N S S Kasyap 860 Reputation points Microsoft External Staff
2025-03-12T16:37:30.8966667+00:00 @PK PK
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer