In the need to access data via SQL endpoint only Managed tables and shortcuts are exposed, but external tables are not.
Managed tables delete underlying files when they are been deleted from Lakehouse. External tables and shortcuts don't delete underlying files.
Creating a shortcut via code (notebook) allows you access the data via SQL endpoint and to keep delta files when deprecating a table. However, shortcuts can only be created via KSQL and Lakehouse UI.
It will be great to have a feature to create a shortcut from code (Notebook).
4 Comments
I think the API for this comes with this feature, so that a python SDK around it would be possible afterwards:
https://learn.microsoft.com/en-gb/fabric/release-plan/onelake#shortcut-api
In addition maybe the creation of multiple shortcuts at once might already be helpful for you:
https://blog.fabric.microsoft.com/en-us/blog/create-multiple-shortcuts-faster-and-easier/
JugiMicrosoft Employee
Now possible via:
https://semantic-link-labs.readthedocs.io/en/stable/sempy_labs.lakehouse.html#sempy_labs.lakehouse.create_shortcut_onelake
- Status added:New
