How to Attach a Default Lakehouse to a Notebook in Fabric

Great blog!

I'm wondering, is it possible to switch the default Lakehouse multiple times within a Notebook run?

If I understand correctly, changing the default Lakehouse by using the '%% configure' approach will only work properly if this is done in the first cell in the Notebook. I guess that means we can only set the default Lakehouse once in a Notebook run.

Some users want to be able to switch default Lakehouse programmatically multiple times within a Notebook run, in order to use Spark SQL on multiple Lakehouses within the same Notebook run.