How to pass error details from Snowflake stored procedure to ADF script activity using the new Snowflake connector?
Since switching to the new Snowflake connector in ADF, error messages from Snowflake stored procedures don't seem to be being passed back to the calling Script activity in ADF as before. Is this intended behaviour, e.g. is there a recommended process for handling errors?
Using the legacy connector, errors are passed back as they are raised:
But using the new connector, we get a generic and not entirely useful message:
Both scripts are identical, calling a stored proc that just raises an exception, and the two linked services are identical other than one being the legacy connector and one being the new.
Thanks