How to pass error details from Snowflake stored procedure to ADF script activity using the new Snowflake connector?

Tom Dann 0 Reputation points
2024-04-25T10:54:06.9366667+00:00

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:

User's image

But using the new connector, we get a generic and not entirely useful message:

User's image

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,750 questions
{count} votes