topic Re: How to Transfer Hive Metastore from One Workspace to Another in Data Governance

How to Transfer Hive Metastore from One Workspace to Another

jv_v — Mon, 01 Jul 2024 07:38:37 GMT

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?

Re: How to Transfer Hive Metastore from One Workspace to Another

Giri-Patcham — Tue, 02 Jul 2024 06:28:54 GMT

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

Re: How to Transfer Hive Metastore from One Workspace to Another

jacovangelder — Tue, 02 Jul 2024 10:02:48 GMT

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.

Re: How to Transfer Hive Metastore from One Workspace to Another

jose_gonzalez — Mon, 22 Jul 2024 17:53:49 GMT

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

Re: How to Transfer Hive Metastore from One Workspace to Another

jv_v — Tue, 23 Jul 2024 05:52:03 GMT

Managed tables, External tables, Views etc.,

Re: How to Transfer Hive Metastore from One Workspace to Another

hps2 — Tue, 01 Oct 2024 20:26:38 GMT

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