External Tables in Fabric

[mpolonskiy5637]

Hello,

reading and understanding more about shortcuts in Fabric it seems like Unmanaged / External Tables are useless.

The main point of an external Table in Spark is to leave data where it is and have a table which references this data. Thus only metadata is managed by spark and deleting this table does not effect the original data. Is this not exactly what a shortcut in fabric is? Why would I even create an External Table in Fabric and what is the point of a shortcut external table, which is technically possible but does not seem to make much sense.

[AndyDDC · Accepted solution]

IMHO it's about choice. Leave the data where it is in the external storage and simply create a shortcut to it, no need to create an external table over that data. With External Tables you could choose to create them over file data in the Files area of the Lakehouse (for example). Shortcuts just bypass the step of you having to define the external table definition