topic Re: Two or more lakehouse in Visual Query editor in Data Warehouse

Two or more lakehouse in Visual Query editor

PanuO — Thu, 23 Jan 2025 13:29:33 GMT

I have a Visual Query where I would like to join two tables from different lakehouses. Query editor shows this error when I add table from second lakehouse and based on error it seems to try to query that table from first lakehouse.

Is there a known restriction, that Visual Query editor does not support more than one lakehouse?

Re: Two or more lakehouse in Visual Query editor

nilendraFabric — Thu, 23 Jan 2025 14:50:22 GMT

Hi PanuO

The Visual Query Editor in Microsoft Fabric is primarily designed to work within a single Lakehouse or data source at a time. This means that while you can perform operations like merging or joining tables within the same Lakehouse using the editor, it does not natively support querying or joining tables from multiple Lakehouses simultaneously.

If you need to work with data from multiple Lakehouses in the Visual Query Editor, you can create shortcuts to reference tables from other Lakehouses within a single Lakehouse context. This effectively brings data from multiple sources into one place for querying.

Othe ways to join data :

Cross-Database Querying:

Cross-database or cross-Lakehouse querying is supported in Microsoft Fabric, but it requires using SQL editors or Notebooks with three-part naming conventions (e.g., [workspace].[lakehouse].[table]) rather than the Visual Query Editor

Hope this helps

Thanks

PanuO

Re: Two or more lakehouse in Visual Query editor

PanuO — Fri, 24 Jan 2025 07:16:20 GMT

Thank you nilendraFabric, I was a bit afraid of this answer, but I understand it. Visual Query tool is great for people who don't know SQL and want to export data into Excel file and hopefully it will receive cross-lakehouse query support in near future.