Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
mpolonskiy5637
Frequent Visitor

External Tables in Fabric

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.

 

1 ACCEPTED SOLUTION
AndyDDC
Super User
Super User

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

View solution in original post

1 REPLY 1
AndyDDC
Super User
Super User

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.