cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

UC external tables to managed tables

frosti_pro
New Contributor

Dear community,

 
I would like to know if there are any procedure and/or recommendation to safely and efficiently migrate UC external tables to managed tables (in a production context with high volume of data)?
 
Thank you for your support!
2 REPLIES 2

ashraf1395
Honored Contributor

Hi there @frosti_pro , 
So you can have a look at this blog https://www.databricks.com/blog/migrating-tables-hive-metastore-unity-catalog-metastore , helped me a lot when we were doing migrations for a client

There's a tool from databricks called databricks-ucx which is used for migration from hive metastore to UC. 
You can also have a look at it for migrating from external to managed tables will get an idea or step required
https://databrickslabs.github.io/ucx/docs/process/#migrate-hive-metastore-data-objects

Your usecase is different you want to migrated from UC external to managed , so not all the things will be same but you can get an idea on how to plan the procedure for production

Thank you @ashraf1395 for your reply! I am surprised to see there is no official procedure for my usecase. Thank you again.

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now