How do you access or use tables in the unity catalog?

How do you access or use tables in the unity catalog?
A . schema_name.table_name
B. schema_name.catalog_name.table_name
C. catalog_name.table_name
D. catalog_name.database_name.schema_name.table_name
E. catalog_name.schema_name.table_name

Answer: E

Explanation:

The answer is catalog_name.schema_name.table_name

Graphical user

interface, diagram

Description automatically generated

Note: Database and Schema are analogous they are interchangeably used in the Unity catalog.

FYI, A catalog is registered under a metastore, by default every workspace has a default metastore called hive_metastore, with a unity catalog you have the ability to create meatstores and share that across multiple workspaces.

Diagram

Description automatically generated

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments