topic Getting status of "If Condition" Activity into a variable in Data Engineering

Getting status of "If Condition" Activity into a variable

sreedata — Tue, 03 Jan 2023 11:38:47 GMT

"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

Re: Getting status of "If Condition" Activity into a variable

Hubert-Dudek — Tue, 03 Jan 2023 11:42:46 GMT

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.

Re: Getting status of "If Condition" Activity into a variable

UmaMahesh1 — Tue, 03 Jan 2023 13:03:08 GMT

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..

Re: Getting status of "If Condition" Activity into a variable

sreedata — Thu, 12 Jan 2023 15:34:18 GMT

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

Re: Getting status of "If Condition" Activity into a variable

sreedata — Thu, 12 Jan 2023 15:35:45 GMT

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