Functional Difference between managed and external tables UC

[carlosjrestr]

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​

[-werners-]

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.

[carlosjrestr]

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?

[Anonymous]

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!