https://community.databricks.com/t5/data-governance/upgrade-your-hive-tables-and-views-to-unity-catalog/m-p/96680#M2218 <P>Do you need to upgrade your Hive tables and Views to Unity Catalog?</P><P>You have the below options available which you can select based on the requirements:</P><P><STRONG>UCX</STRONG>: A command-line utility suite for comprehensive Unity Catalog migrations, ideal for large Hive metastore upgrades, supporting both managed and external tables with bulk migration options for advanced users comfortable with scripts.</P><P><STRONG>Unity Catalog Upgrade Wizard</STRONG>: A visual tool for quickly upgrading Hive tables to Unity Catalog external tables, suitable for users preferring a GUI and featuring optional scheduled syncs for hybrid Hive-Unity Catalog setups.</P><P><STRONG>SYNC SQL Command</STRONG>: A SQL-based approach to upgrade Hive tables to Unity Catalog external tables, ideal for SQL users needing scheduled syncs, though it requires CREATE TABLE CLONE for managed tables in Databricks storage.</P><P><STRONG>CREATE TABLE CLONE SQL Command</STRONG>: A method for migrating Delta-format Hive managed tables to Unity Catalog managed tables, preserving metadata with simple syntax and preferred over CREATE TABLE AS SELECT for streamlined upgrades.</P><P><A href="https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html" target="_blank">https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html</A></P><P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/127895">@Advika_</a>&nbsp;</P> Tue, 29 Oct 2024 16:16:54 GMT Sourav-Kundu 2024-10-29T16:16:54Z https://community.databricks.com/t5/data-governance/upgrade-your-hive-tables-and-views-to-unity-catalog/m-p/96680#M2218 <P>Do you need to upgrade your Hive tables and Views to Unity Catalog?</P><P>You have the below options available which you can select based on the requirements:</P><P><STRONG>UCX</STRONG>: A command-line utility suite for comprehensive Unity Catalog migrations, ideal for large Hive metastore upgrades, supporting both managed and external tables with bulk migration options for advanced users comfortable with scripts.</P><P><STRONG>Unity Catalog Upgrade Wizard</STRONG>: A visual tool for quickly upgrading Hive tables to Unity Catalog external tables, suitable for users preferring a GUI and featuring optional scheduled syncs for hybrid Hive-Unity Catalog setups.</P><P><STRONG>SYNC SQL Command</STRONG>: A SQL-based approach to upgrade Hive tables to Unity Catalog external tables, ideal for SQL users needing scheduled syncs, though it requires CREATE TABLE CLONE for managed tables in Databricks storage.</P><P><STRONG>CREATE TABLE CLONE SQL Command</STRONG>: A method for migrating Delta-format Hive managed tables to Unity Catalog managed tables, preserving metadata with simple syntax and preferred over CREATE TABLE AS SELECT for streamlined upgrades.</P><P><A href="https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html" target="_blank">https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html</A></P><P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/127895">@Advika_</a>&nbsp;</P> Tue, 29 Oct 2024 16:16:54 GMT https://community.databricks.com/t5/data-governance/upgrade-your-hive-tables-and-views-to-unity-catalog/m-p/96680#M2218 Sourav-Kundu 2024-10-29T16:16:54Z https://community.databricks.com/t5/data-governance/upgrade-your-hive-tables-and-views-to-unity-catalog/m-p/97551#M2234 <P>Thank you for sharing these upgrade options <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/128004">@Sourav-Kundu</a>! It’s helpful to have a clear understanding of the different approaches available for migrating Hive tables to Unity Catalog.</P> Mon, 04 Nov 2024 14:33:32 GMT https://community.databricks.com/t5/data-governance/upgrade-your-hive-tables-and-views-to-unity-catalog/m-p/97551#M2234 Advika_ 2024-11-04T14:33:32Z