Question asked in Unity Catalog Databricks course

issibra — Tue, 23 May 2023 20:19:00 GMT

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 !

Re: Question asked in Unity Catalog Databricks course

issibra — Fri, 26 May 2023 19:11:07 GMT

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:

A 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