issue: when an exception happens in azure datafactory notebooks only just a url contianing the details is sent back to the datafactory, it does not go to the error flow.
one of the solutions we implemented was to catch an exception in the notebook is to send a json string containing the following
“ExceptionDetails”:”some exception happend”
then datafactory will parse the json object log it if it wants and then choose the appropriate flow to handle the exception.
if you want to terminate the pipeline then do something like the following, where in use dynamic sql to raise an error.
azure data factory 2 – How do I raise an error from if activity in ADFV2? – Stack Overflow
hope this helps..