Automatically assign lakehouse to new workspace that is created

[gori137]

Hello all, I'm wondering if there's an option to automatically assign certain lakehouse when the workspace is created (and when you go to the notebook). I want to avoid manually linking certain lakehouse to the notebook.

Thanks!

[sheelaramnarain]

Hi Team, 

I tried to use %% configure to set the default lakehouse in notebook still fails . Not sure how to make it work 

[v-cboorla-msft]

Hi @gori137 

Thanks for using Microsoft Fabric Community.

Microsoft Fabric currently doesn't automatically assign a specific lakehouse to a notebook when the workspace is created. But, you can add multiple lakehouses to the same notebook. By switching the available lakehouse in the left panel, you can explore the structure and the data from different lakehouses. In the lakehouse list, the pin icon next to the name of a lakehouse indicates that it's the default lakehouse in your current notebook. 

For additional information please refer to the below documentations:

Link 1 : Connect lakehouses and notebooks.

Link 2 : Switch lakehouses and set a default.

However, your suggestion is definitely valuable! We use customer feedback like yours to prioritize future features. The more users who request the ability to customize backgrounds, the higher it moves on our list.

Appreciate if you could share the feedback on our Microsoft Fabric Ideas. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

[gori137]

Hello, thanks for your response. In the meantime, I found a community post with the same issue. It seems that there's a solution to attach a lakehouse to a workspace by the code. For me the code didn't work because %%configure command doesn't work.

https://community.fabric.microsoft.com/t5/General-Discussion/How-to-set-default-Lakehouse-in-the-not...

[v-cboorla-msft]

Hi @gori137 

Apologies for the delay in reponse.

The error message "UsageError: Line magic function '%%configure' not found" indicates that the %%configure magic command is not recognized by your current kernel in Microsoft Fabric Notebook.

Kernel mismatch: The %%configure magic command is specifically designed for use with the Spark kernel in Fabric Notebooks. If you are using a different kernel, like Python or R, then the %%configure command won't be available.

For additional information please refer : Spark session configuration magic command

I hope this information helps.

Thank you.

[v-cboorla-msft]

Hi @gori137 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thank you.

[v-cboorla-msft]

Hi @gori137 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thank you.