Search code examples
azure-synapseazure-synapse-analytics

Parameterized invoking of notebooks does not work

I am trying to run multiple notebooks from the data we have, so I am using for each and @item().NotebookName. However, Synapse is failing, it can't find the notebook, even though notebook name is clearly the same as the value passed. Am I missing something? These notebooks are still in my branch. I guess I will need to use mssparkutils.notebook.run

pipelinePic

insidepipeline

Solution

  • One possible reason is, when you are invoking the notebook where notebook name specified with a dynamic expression, the particular notebook should be published prior to that or else it will give the below error.

    enter image description here

    Here, I got same error when notebook name given through dynamic expression and notebook was not published.

    enter image description here

    It will identify the unpublished notebooks only when we are giving the notebook from the dropdown.

    enter image description here

    So, publish all your notebooks before the pipeline execution and then debug the pipeline. Now, it will identify the notebook from the dynamic expression.

    enter image description here