Forum Discussion

KrishnaMoola's avatar
KrishnaMoola
Regular Visitor
8 months ago
Solved

Attach multiple lakehouse to a single notebook.

I have a notebook and have attached to a lakehouse. The default lakehouse is called metadata, where I keep details about the job runs. Now, I have created Silver lakehouse and within a notebook at ea...
data engineering
lakehouse
notebook
  • KrishnaMoola's avatar
    KrishnaMoola
    7 months ago

    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

chetanhiwale's avatar
chetanhiwale
Icon for Resolver I rankResolver I
8 months ago

Hi KrishnaMoola 

In Fabric, the spark catelog only keeps the default lakehosue tables and schemas. Thus you are not able to access the other lakehouse(silver lakehouse) tables. The most appropriate option would be to use ABFS path. 
Other than that if you are using spark.sql  you can use first convert the dataframe in VIEW and then perform sql operations. 


Hope this helps. Let me know if you have any futher question , we can discuss !!