Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

notebook parameter

hello

in the fabric lakehouse notebook, how can I create parameters ? so that I can pass values to from ADF pipeline

thanks

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Thanks for using Fabric Community.
    As I understand you are looking for options to pass parameters from data pipeline to notebook.

    Yes, it is possible to pass parameters from a notebook activity (data pipeline) to a notebook in Microsoft Fabric. To do this, you can use the Settings tab of the Notebook activity. In the Settings tab, under the Parameters section, you can add parameters that you want to pass to the notebook. The parameters can be of any type, such as strings, numbers, or arrays.

     

    Here are the steps you can follow:

     

    Step1: Create a notebook with required parameters. And make sure to select “toggle parameter cell” under more commands.

     

     

     

    Step 2: Create a Pipeline for notebook activity and select the notebook in the settings option which you have created. And pass the parameters under “base parameters”.

     

    Note : Name should be same in base parameters and notebook in order to pass the parameter.

     

     

     

    Hope this is helpful. Please let me know incase of further queries.

     

     

8 Replies

Replies have been turned off for this discussion
  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Thanks for using Fabric Community.
    As I understand you are looking for options to pass parameters from data pipeline to notebook.

    Yes, it is possible to pass parameters from a notebook activity (data pipeline) to a notebook in Microsoft Fabric. To do this, you can use the Settings tab of the Notebook activity. In the Settings tab, under the Parameters section, you can add parameters that you want to pass to the notebook. The parameters can be of any type, such as strings, numbers, or arrays.

     

    Here are the steps you can follow:

     

    Step1: Create a notebook with required parameters. And make sure to select “toggle parameter cell” under more commands.

     

     

     

    Step 2: Create a Pipeline for notebook activity and select the notebook in the settings option which you have created. And pass the parameters under “base parameters”.

     

    Note : Name should be same in base parameters and notebook in order to pass the parameter.

     

     

     

    Hope this is helpful. Please let me know incase of further queries.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous ,

      Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.

    • danjo914's avatar
      danjo914
      Frequent Visitor

      So that is returning values from the notebook to the pipeline.. What about in the reverse, and passing parameters from the pipeline to the notebook. Use case being incremental or full load parameter being passed.

      • danjo914's avatar
        danjo914
        Frequent Visitor

        Ah I see, it is possible.. just set up the parameter and value, then in the notebook just use the name of parameter. Very straight forward.

    • SachinNandanwar's avatar
      SachinNandanwar
      Impactful Individual

      If the value of the name parameter is not set inside the notebook so would "Output" get printed ?

      I have a use case where the item value of foreach acitivity in a data pipeline need to be set to a base parameter which will then be processed in the notebook but the notebook errors out with not found error