Forum Discussion
Helper IITwo or more lakehouse in Visual Query editor
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
Super UserHi 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
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.
