01-03-2023 03:38 AM
"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
01-03-2023 05:03 AM
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..
01-03-2023 03:42 AM
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.
01-12-2023 07:35 AM
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
01-03-2023 05:03 AM
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..
01-12-2023 07:34 AM
Thanks .This helped.Set a base parameter to the notebook with status sucess or fail
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group