Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
How to pass error details from Snowflake stored procedure to ADF script activity using the new Snowflake connector?
![](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(163.2, 73%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tom Dann
0
Reputation points
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
{count} votes
-
AnnuKumari-MSFT 32,161 Reputation points Microsoft Employee2024-04-25T19:47:06.6266667+00:00 Hi Tom Dann ,
Welcome to Microsoft Q&A platform and thanks for posting your query here.
As per my understanding , you are facing an issue with the new Snowflake connector in Azure Data Factory where error messages from Snowflake stored procedures are not being passed back to the calling Script activity in ADF as before.
I would take this issue forward to the internal team to get more details on this issue and will keep you updated once I get some response . Thankyou
-
![](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(224.00000000000003, 95%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
FERNANDO BASAEZ 0 Reputation points2024-05-03T01:29:28.57+00:00 Some one have found the solutuion for this? I facing the same issue.
-
AnnuKumari-MSFT 32,161 Reputation points Microsoft Employee
2024-05-15T08:36:07.95+00:00 Tom Dann ,
As per the communication from the internal team , The fix for this issue "script activity doesn’t show snowflake detailed error message" would be deployed globally by next month. Thankyou
-
![](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(0, 54%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Madapati, Srikanth 0 Reputation points2024-05-21T17:32:46.8333333+00:00 Hi AnnuKumari,
May we know that what is the exact date in next month?
Sign in to comment