In synapse pipeline , i am using a notebook activity in pipeline, can i get the notebook name dynamically to a variable.

Question

In synapse pipeline , i am using a notebook activity in pipeline, can i get the notebook name dynamically to a variable.

Answer 1

Hello @Sreedevi, Ramagiri (Cognizant)

Wanted to check the scenario!

1. Wanted to pass the Notebook Name to the Notebook activity Dynamically?

Like the below image shows? pass the Notebook name to the Activity?

2. Wanted to Know what is the Notebook Name which is being used by the Notebook Activity?

For scenario # 2, below tried to capture the Notebook name by using the Set-Variable.

Below is the Expression:

@activity('Notebook1').output.status.Output.status.livyInfo.jobCreationRequest.conf['spark.synapse.context.notebookname']

A typical Notebook activity output looks like the below image, and we can parse the output to find which Notebook was used!!!

Please let us know which scenario we are trying over here? thanks for your understanding.

Answer 2

Hello @SatishBoddu-MSFT,

I have completed "Accept Answer" and short survey.
Please let me know if any other action required from my end.

Thank you