topic Re: Performance b/w Managed Table and Un-Managed table in Data Engineering

Performance b/w Managed Table and Un-Managed table

param3sh — Thu, 09 Feb 2023 16:00:25 GMT

I am using Databricks in Azure. I want to mount ADLS Gen2 on Databricks and create unmanged (external) tables on the mount point. But before that I want to know which will give best performance, is it Managed table (stores data in DBFS root)or Un-managed(stores data in ADLS Gen2)?

Re: Performance b/w Managed Table and Un-Managed table

Lakshay — Fri, 10 Feb 2023 19:34:03 GMT

Hi @Paramesh Malla , I would expect both tables to perform equally well.

Re: Performance b/w Managed Table and Un-Managed table

Anonymous — Sun, 09 Apr 2023 06:58:38 GMT

Hi @Paramesh Malla

Thank you for your question! To assist you better, please take a moment to review the answer and let me know if it best fits your needs.

Please help us select the best solution by clicking on "Select As Best" if it does.

Your feedback will help us ensure that we are providing the best possible service to you. Thank you!

Re: Performance b/w Managed Table and Un-Managed table

Debayan — Mon, 13 Feb 2023 05:35:08 GMT

Hi, depending on the network settings and speed sometimes external points are slow, otherwise the performance for both of the tables are almost same.