Snowflake stored procedure called from ADF
I am trying to call Snowflake stored procedure from ADF (lookup activity)that inserts the log count of all tables once it gets extracted from source/loads into snowflake. Stored procedure throws error when it is not able to insert log of a particular table in the loop but overall when it is done with process (log counts for all) it shows only success in the look up activity even when it is failed for some tables. How can I fail the pipeline in this case? In try, I am just extracting the table details and load count and in catch I am executing below : catch (err) { throw Failed to insert data change to log, error: ${err}Failure during copy from blob to sql db using ADF
Hello, I get this error when using Azure Data Factory for copying from blob to azure SQL DB:- Database operation failed. Error message from database execution : ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.. I am able to connect to my DB using SSMS and I have enabled firewall to connect to Azure services. Has anyone faced this error when using ADF / know how to fix it? Thanks in advance.
