topic Creating Warehouse Shortcuts in Data Warehouse

Creating Warehouse Shortcuts

jashfabric — Thu, 16 May 2024 12:22:10 GMT

Hey all

I'm familiar with creating shortcuts within Microsoft Fabric. I can create shortcuts in a Lakehouse pointing to another Lakehouse, another Warehouse within the same workspace, or even a Warehouse in a different workspace. However, the option to create shortcuts seems to be missing from Warehouses themselves.

Here's what I'd like to clarify:

Is it currently possible to create a shortcut directly from a Warehouse in a different workspace to my current Warehouse?
If creating a shortcut from a Warehouse isn't supported, are there any alternative approaches to access data from a Warehouse in another workspace within Fabric?

Appreciate all kinds of help.
Anonymous

Re: Creating Warehouse Shortcuts

Anonymous — Fri, 17 May 2024 05:55:41 GMT

Hi jashfabric
Thanks for using Fabric Community.

In Microsoft Fabric, you can create shortcuts only in Lakehouses and KQL databases. Currently, the option to create shortcuts directly from a Warehouse is not available.
OneLake shortcuts - Microsoft Fabric | Microsoft Learn

You can use an alternative as below:

Cross-Workspace Query:
You can create a lakehouse in the same workspace as your current Warehouse. In that lakehouse, create a shortcut pointing to the required databases or tables from the Warehouse in the other workspace. You can then query tables in that lakehouse which are just shortcuts to the Warehouse.
Data warehouse tutorial - Create queries cross-warehouse with the SQL query editor - Microsoft Fabric | Microsoft Learn

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

Re: Creating Warehouse Shortcuts

jashfabric — Fri, 17 May 2024 07:55:01 GMT

Thank you Anonymous
I hope this feature would be available in the future.
Thanks again.

Re: Creating Warehouse Shortcuts

AzizQuazi — Thu, 26 Sep 2024 00:50:06 GMT

Hi jashfabric , could you please review your answer - my understanding is that you can not create shortcuts in a Lakehouse that point to tables in a Warehouse.

Re: Creating Warehouse Shortcuts

Anonymous — Tue, 07 Jan 2025 20:11:27 GMT

Hi Anonymous , will this feature be available anytime in the future/is it currently being developed? I am specifically referring to: be able to query SQL Analytics endpoints of Fabric Warehouses across workspaces.