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}