Lakehouse data from Warehouse

Hi. Dependding on the user experience you are looking for, you can query in different ways. For example, thelakehouse spark catalog (Tables section) can be query by the Warehouse SQL user experience.

Generally speaking when querying and exploring datalake, people pick notebooks for that. If you think about it, there only onelake. On top of that you have lakehouse or warehouse. If you click at the properties of table or file you can find the path to onelake. So you could query both of them with a notebook.

Again, it depends on the user experience you are looking for.

I hope that helps,

Hi jashfabric 
Thanks for using Fabric Community.
Microsoft Fabric enables you to easily cross reference Lakehouse and Warehouse data. To query Lakehouse data from Warehouse, you need to have both artifacts in the same Fabric workspace. Fabric workspaces have a cross-database query capability that enables you to query Lakehouse data from your Warehouse using T-SQL.
For more information please refer to this link:

https://www.linkedin.com/pulse/querying-lakehouse-data-from-warehouse-microsoft-fabric-jovan-popovic/

Hope this helps. Please let me know if you have any further queries.

Hi jashfabric 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks