Parameterizing a notebook

[pmscorca]

Hi,

I'd like to know if a notebook could be parameterized and how.

Any suggests to me, please? Thanks

[Anonymous · Accepted solution]

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.

2. 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!