Forum Discussion

mpolonskiy5637's avatar
mpolonskiy5637
Frequent Visitor
2 years ago
Solved

Shortcut Managed Table

Hello,   I am trying to understand what a Shortcut Managed Table even is? According to Spark Definition a Managed Table is a table which is stored in the Fabric Tables section and data as well as ...
  • AndyDDC's avatar
    2 years ago

    The Tables section of a Lakehouse is for both managed and unmanaged tables. So you can create a managed table and as you say data will be deleted along with the table if you delete it. You can also create an unmanaged table in the Tables section eg over data in the Files area of a Lakehouse, and yes data won't be deleted.

     

    Shortcuts are just a quick way of referencing external data without having to manage a table definition.

     

    However with shortcuts you need to be careful as you can delete the source files if you select a folder or file under the shortcut and delete. Deleting the shortcut definition itself won't delete the source data.