I believe I have found the solution. It is possible to parameterize %%configure like this %%configure { "defaultLakehouse": { "name": { "parameterName": "defaultLakehouseName", "defaultValue": "FourthLakehouse" }, "id": { "parameterName": "defaultLakehouseId", "defaultValue": "773faa37-826f-4f9b-830f-e2a7a23e3903" } } } I am using it to programmatically drop unnecessary tables in various lakehouses, but I also think I will use it to apply optimize, vacuum and vorder operations to tables. hope it helps