Read tables from a second Lakehouse in the same Fabric notebook

I am working in Microsoft Fabric and need to use two Lakehouses in the same notebook (later inner join between 2 tables from 2 lakehouse or join using 2 dataframes).

I can read data from the default Lakehouse (for example: df_mean = spark.sql(sql_trainer)), but I cannot read tables from a second Lakehouse that is not set as default.

What is the correct way to read tables from the second Lakehouse?

5 comments