Forum Discussion
Attach multiple lakehouse to a single notebook.
Hi V-yubandi-msft , sorry for coming back late on this, I was on leave and not feeling well. The issue is resolved now. Was able to attach multiple lakehouses to the notebook which resolved the issue
I have given GatewayLogs.dbo.table1 but still no luck, so have created a shortcut to the metadata lakehouse and this works. I am not sure if this is correct way to do
Community SupportHi KrishnaMoola ,
Thanks for the update. Creating a shortcut will work because it exposes the Silver table inside your default lakehouse, so Spark is able to resolve it. However, this is more of a workaround.
The recommended approach is to attach the Silver lakehouse as a Data item in the notebook. Once both lakehouses are attached, the tables in Silver should be recognised directly using the standard namespace format.
So your shortcut isn’t incorrect but attaching the Silver lakehouse as a data item is cleaner and keeps the table where it belongs.
If you still can’t reference the tables after attaching the Silver lakehouse, please let us know and we’ll help investigate further