How to pass parameters to notebook to be used in %%configure cell

[amaaiia]

I want to configure the default lakehouse of my notebook programatically, I want the default lakehouse to be passed through parameters.

I've found a way to configure the default lakehouse with %%configure script:

It works if I directly write the lakehouse name, id and workspace id in the same cell, and I run this cell the first one before the rest of the cells. But I want these three values to be passed by parameter, so I need to run parameters cell before %%configure cell, and if I do that, I get and error:

MagicUsageError: The current running Livy session must be restarted for the config changes to take effect. Specify the argument "-f" to force restarting Livy session. Any variables stored in memory will be cleared.

So, how can I pass the parameters to %%configure cell if I have to run %%configure cell before any other to work?

[Expiscornovus · Accepted solution]

Hi @amaaiia,

You can use Parameterized session configuration for this:

https://learn.microsoft.com/en-us/fabric/data-engineering/author-execute-notebook#parameterized-sess...

Below is an example code snippet

%%configure  

{ 
    "defaultLakehouse": { 
        "name": {
                  "parameterName": "defaultLakehouseName",
                  "defaultValue": "FourthLakehouse"
        },
        "id": {
                  "parameterName": "defaultLakehouseId",
                  "defaultValue": "773faa37-826f-4f9b-830f-e2a7a23e3903"
        }
    }
}

[amaaiia]

It works!!

[Ben1489]

Is there a way to supply additional parameteres for use later on in the notebook?