D𝐲𝐧𝐚𝐦𝐢𝐜𝐚𝐥𝐥𝐲 𝐬𝐞𝐭 𝐲𝐨𝐮𝐫 𝐝𝐞𝐟𝐚𝐮𝐥𝐭 𝐥𝐚𝐤𝐞𝐡𝐨𝐮𝐬𝐞 for Notebooks

Hey Microsoft Fabric folks, now you can 𝐝𝐲𝐧𝐚𝐦𝐢𝐜𝐚𝐥𝐥𝐲 𝐬𝐞𝐭 𝐲𝐨𝐮𝐫 𝐝𝐞𝐟𝐚𝐮𝐥𝐭 𝐥𝐚𝐤𝐞𝐡𝐨𝐮𝐬𝐞 in Microsoft Fabric notebooks—it's now generally available and makes managing environments easy!

This can be done even across workspaces using variable library values, so no more manual UI Lakehouse attachment needed, when switching dev/test/prod.

Here's how to set it up - super easy:

• First, create a 𝐕𝐚𝐫𝐢𝐚𝐛𝐥𝐞 𝐋𝐢𝐛𝐫𝐚𝐫𝐲 in your workspace (e.g., name it "myVL").

• Add string variables like:

- LHname → your lakehouse name

- LHid → lakehouse ID (needed only for cross-workspace)

- WorkspaceId → target workspace ID (needed only for cross-workspace)

• In your notebook, make the 𝐯𝐞𝐫𝐲 𝐟𝐢𝐫𝐬𝐭 𝐜𝐞𝐥𝐥 a 𝐏𝐲𝐒𝐩𝐚𝐫𝐤 cell and add this code:

%%configure

{

"defaultLakehouse": {

"name": {

"variableName": "$(/**/myVL/LHname)"