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

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