Forum Discussion

pmscorca's avatar
pmscorca
Kudo Kingpin
2 years ago
Solved

Parameterizing a notebook

Hi, I'd like to know if a notebook could be parameterized and how. Any suggests to me, please? Thanks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi pmscorca ,

     

    Yes, you can parameterize notebooks in Fabric Lakehouse, I have two ways here.

     

    1. You can pass parameters from a data pipeline to a notebook in Fabric Lakehouse:

     

    1. Create a notebook with parameters:

     

    In the notebook, define the parameters you want. Make sure to select the Toggle Parameter Cell option under More Commands.

     

     

    1. Create a pipeline for the Notebook activity:

     

    In the pipeline, add a Notebook activity and select the notebook you created.

     

    In the Settings tab of the Notebook activity, under the Parameters section, add the parameters you want to pass to the notebook. Make sure the parameter names match the parameter names in the notebook.

     

    2. You can also configure the default lakehouse programmatically by passing parameters to the cell:

     

    Define the parameters in the notebook:

    # Parameters
    defaultLakehouseName = "MyLakehouse"
    defaultLakehouseId = "12345"

     

    Set the parameters using %%configure:

    %%configure
    {
        "defaultLakehouse": {
            "name": {"parameterName": "defaultLakehouseName", "defaultValue": "MyLakehouse"},
            "id": {"parameterName": "defaultLakehouseId", "defaultValue": "12345"}
        }
    }


    For more information on parameterized session configuration, see the following documentation:

    Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!