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: 

Question asked in Unity Catalog Databricks course

issibra
New Contributor III

In Unity catalog part we have this question:

A data engineer needs to copy an external table from their default Hive metastore to the Unity Catalog metastore. 

Which of the following are required to upgrade the table to be managed by Unity Catalog? Select three responses.  

  • The data engineer must have workspace administrator level privileges.
  • The data engineer must be granted CREATE EXTERNAL TABLE permission on the external location of the table to be upgraded. 
  • The data engineer must create their own Hive metastore.  
  • The data engineer must have the file path to an external location that references the storage credential. 
  • The data engineer must have a storage credential with an IAM role that authorizes Unity Catalog to access the tables’ location path. 

1st, 3rd and 5th responses are the correct ones accoring to the correction,

why ? do we need to create our own hive metastore and have administrator privliges to do that ?

Can we have two hive metastore ?

Thank you !

1 ACCEPTED SOLUTION

Accepted Solutions

issibra
New Contributor III

I think it was a mistake in the mentionned correction in Databricks

according to the documentation

Upgrade a single external table to Unity Catalog

You can copy an external table from your default Hive metastore to the Unity Catalog metastore using the Data Explorer.

Requirements

Before you begin, you must have:

  • storage credential with an IAM role that authorizes Unity Catalog to access the table’s location path.
  • An external location that references the storage credential you just created and the path to the data on your cloud tenant.
  • CREATE EXTERNAL TABLE permission on the external location of the table to be upgraded.

which bring to the 2nd, 4th and 5th answers.

Thank you for everyone

View solution in original post

1 REPLY 1

issibra
New Contributor III

I think it was a mistake in the mentionned correction in Databricks

according to the documentation

Upgrade a single external table to Unity Catalog

You can copy an external table from your default Hive metastore to the Unity Catalog metastore using the Data Explorer.

Requirements

Before you begin, you must have:

  • storage credential with an IAM role that authorizes Unity Catalog to access the table’s location path.
  • An external location that references the storage credential you just created and the path to the data on your cloud tenant.
  • CREATE EXTERNAL TABLE permission on the external location of the table to be upgraded.

which bring to the 2nd, 4th and 5th answers.

Thank you for everyone

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!