Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
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.
Solved! Go to 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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
53 | |
6 | |
5 | |
4 | |
3 |
User | Count |
---|---|
67 | |
12 | |
12 | |
7 | |
6 |