Forum Discussion
Get data into data warehouse using shortcuts
How to get data into a data warehouse by using shortcuts?
I cannot find it in the Get Data options of the data warehouse:
In the Lakehouse, I find shortcut as an option in Get Data:
Hi fabricator1 You can only create a shortcut to a Warehouse from a Lakehouse. You are not able to create a Shortcut in a Warehouse to another resource.
Hi fabricator1, You can create a new lakehouse, add shortcut to it. And then in the warehouse, you can add the lakehouse which will expose the shortcut data as well.
The constraint is both Warehouse and Lakehouse should be in the same workspace.
4 Replies
Hi fabricator1 You can only create a shortcut to a Warehouse from a Lakehouse. You are not able to create a Shortcut in a Warehouse to another resource.
Hi fabricator1, You can create a new lakehouse, add shortcut to it. And then in the warehouse, you can add the lakehouse which will expose the shortcut data as well.
The constraint is both Warehouse and Lakehouse should be in the same workspace.
Thank you govindarajan_d
I guess you are referring to Cross Database Query: Query the SQL analytics endpoint or Warehouse - Microsoft Fabric | Microsoft Learn
Then I understand:- I cannot create a shortcut in a Warehouse.
- I can create a shortcut in a Lakehouse.
- I can use that Lakehouse as a source in a Cross Database Query in the Warehouse.
Yes. That's right.
