Forum Discussion
Creating Warehouse Shortcuts
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 LearnYou 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.
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.
Thank you Anonymous
I hope this feature would be available in the future.
Thanks again.