Functional Difference between managed and external tables UC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-08-2023 06:04 PM
Hi community,
โ
Is there a summary or detail guidance on the functional differeโnce between managed and external tables in unity catalog? Looking at the documentation I can't find any specific functionality in databricks that is supported in managed tables that is not supported in external tables. Assuming I have external tables using delta format what capabilities I will not be able to use if I don't convert them to managed tables?
โ
Thanks
โ
CRโ
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-09-2023 03:07 AM
afaik there are only performance differences.
managed tables should have some performance tweaks. But I haven't tested how much you gain.
I like to have control over my storage so I exclusively use external tables (we have other tools besides databricks that access our data).
And of course, drop table works differently on managed vs unmanaged tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-09-2023 09:09 AM
Thanks. I wonder why we cannot access managed tables directly with non-databricks apps. Once you get the path to the table you need is just a matter of reading the delta file. Does @Adam Pavlackaโ do something to the underlying delta files that make this scenario not supported?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-16-2023 12:07 AM
Hi @Carlos Restrepoโ
Thank you for posting your question in our community! We are happy to assist you.
To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?
This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!

