Shortcuts are objects in OneLake that point to other storage locations. The location can be internal or external to OneLake.
Shortcuts are objects in OneLake that point to other storage locations. The location can be internal or external to OneLake.
How to access the shortcut
Python:
df= spark.read.format("delta").load("Tables/MyShortcut")
display(df)
df= spark.sql("SELECT * FROM MyLakehouse.MyShortcut LIMIT 1000")
display(df)
SELECT TOP (100) * from [MyLakehouse].[dbo].[MyShortcut]
Demo:
Create a new Lakehouse ShortcutLakehouse
Create a Shortcut
Choose the source
Select warehouse
Select a table
Run the query
Move back to Lakehouse view and create New Shortcut again
Select another Lakehouse as source
Select another table Products
So shortcut help us to create a new lakehouse from a different sources and logically group together without being copy the actual data or without any ETL process. You can do further modelling and generates reports on the new shortcuts