cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade your Hive tables and Views to Unity Catalog

Sourav-Kundu
New Contributor III

Do you need to upgrade your Hive tables and Views to Unity Catalog?

You have the below options available which you can select based on the requirements:

UCX: 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.

Unity Catalog Upgrade Wizard: 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.

SYNC SQL Command: 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.

CREATE TABLE CLONE SQL Command: 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.

https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html

@Advika 

1 REPLY 1

Advika
Databricks Employee
Databricks Employee

Thank you for sharing these upgrade options @Sourav-Kundu! It’s helpful to have a clear understanding of the different approaches available for migrating Hive tables to Unity Catalog.

Connect with Databricks Users in Your Area

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