topic Re: How to update change data UnityCatalog table after migrating hive metastore delta table in Data Governance

How to update change data UnityCatalog table after migrating hive metastore delta table

Vivek_Singh — Fri, 03 Mar 2023 06:02:33 GMT

If I will migrate the Hive_metastore table into Unity Catalog table and subsequently hive metastore table is target of curation process. how I will migrate the delta record from Hive_metastore table to Unity Catalog table

Re: How to update change data UnityCatalog table after migrating hive metastore delta table

Vartika — Fri, 31 Mar 2023 06:48:49 GMT

Hi @Vivek Singh Banafar

Hope everything is going great.

Just checking in. Does @Debayan Mukherjee's response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly?

We'd love to hear from you!

Thanks!

Re: How to update change data UnityCatalog table after migrating hive metastore delta table

Debayan — Mon, 06 Mar 2023 05:09:43 GMT

Hi, You can copy complete schemas (databases) and multiple external tables from your default Hive metastore to the Unity Catalog metastore using the Data Explorer upgrade wizard.

Please refer: https://docs.databricks.com/data-governance/unity-catalog/migrate.html#upgrade-tables-and-views-to-unity-catalog