How to Transfer Hive Metastore from One Workspace to Another

[jv_v]

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? 

[Giri-Patcham]

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

[jacovangelder]

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. 

[jose_gonzalez]

Are these tables managed tables or external tables? This is very important step for your migration. 

[jv_v]

Managed tables, External tables, Views etc.,

[hps2]

@jv_v Did you find any solution , I am also looking for same ?