Getting status of "If Condition" Activity into a v...

sreedata · ‎01-03-2023

"If Condition" has lot of activities that can succeeded or fail. If any activity fails then whole "If Condition" fails. I have to get the status of the "If Condition" activity (pass or fail) so that i can use it for processing in the next notebook that follows it.

Please suggest some ways

Thanks

Hubert-Dudek · ‎01-03-2023

Can you share your code? I don't know if python, SQL, or some logic in orchestration tool.

In python, you would need to set try catch in every if statement and use dbutils.notebook.exit('message') to handle it in another notebook.

My blog: https://databrickster.medium.com/

sreedata · ‎01-12-2023

dbutils.notebook.exit('message') .This is also a good way .But since my if activity has multiple notebooks it would get complicated.So setting base parameters from success and fail path helped

UmaMahesh1 · ‎01-03-2023

In your ADF Pipeline activity, set two different pipeline activities from the If condition activity based on success or failure (the green and red arrows).

Then inside each pipeline activity, you can add a set variable, get variable and your adb notebook activities. In set variable, you would be setting the status of your activity using the standard pipeline parameters.

Hope this helps...Cheers..

Uma Mahesh D

View solution in original post

sreedata · ‎01-12-2023

Thanks .This helped.Set a base parameter to the notebook with status sucess or fail

Getting status of "If Condition" Activity into a variable