โ07-01-2024 12:38 AM
Hi everyone,
I need to transfer tables present in the Hive metastore from one workspace to another. My ultimate goal is to migrate these tables to Unity Catalog. I already have a code that will handle the migration to Unity Catalog, but I need help with the steps to copy the tables to the new workspace first.
Could someone guide me through the process?
โ07-01-2024 11:28 PM
Hi @jv_v ,
What is the purpose of transferring tables from Hive metastore from one workspace to another ?
Can you just transfer from Hive metastore to Unity Catalog in the existing workspace and use that Unity Catalog metastore with another workspace ?
Thanks
โ07-02-2024 03:02 AM
Important here is where your data resides. On DBFS or in external storage? if the latter, just use storage mounts to get the data into the new workspace. If DBFS, consider moving the delta tables out of DBFS so you can access it in the new workspace.
โ07-22-2024 10:53 AM
Are these tables managed tables or external tables? This is very important step for your migration.
โ07-22-2024 10:52 PM
Managed tables, External tables, Views etc.,
โ10-01-2024 01:26 PM
@jv_v Did you find any solution , I am also looking for same ?
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group