Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
fabricator1
Advocate II
Advocate II

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:

fabricator1_2-1703171817582.png



In the Lakehouse, I find shortcut as an option in Get Data:

fabricator1_0-1703171753229.png

 

2 ACCEPTED SOLUTIONS
AndyDDC
Solution Sage
Solution Sage

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.

View solution in original post

govindarajan_d
Solution Supplier
Solution Supplier

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. 

View solution in original post

4 REPLIES 4
govindarajan_d
Solution Supplier
Solution Supplier

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. 

AndyDDC
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

MayFabricCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

Top Solution Authors