METASTORES

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above

INFORMATION_SCHEMA.METASTORES describes the current metastore.

Information is displayed only for the current metastore for all users.

This is an extension to the SQL Standard Information Schema.

Definition

The METASTORES relation contains the following columns:

Name	Data type	Nullable	Description
METASTORE_ID	STRING	No	ID of the metastore.
METASTORE_NAME	STRING	No	Name of the metastore.
METASTORE_OWNER	STRING	No	Owner of the metastore.
STORAGE_ROOT	STRING	No	Storage root URL of the metastore.
STORAGE_ROOT_CREDENTIAL_ID	STRING	Yes	ID of the storage credential to access storage root.
STORAGE_ROOT_CREDENTIAL_NAME	STRING	Yes	Name of the storage credential to access storage root.
DELTA_SHARING_SCOPE	STRING	No	OpenSharing scope for the metastore.
DELTA_SHARING_RECIPIENT_TOKEN_LIFETIME	LONG	Yes	The lifetime of OpenSharing recipient tokens in seconds.
DELTA_SHARING_ORGANIZATION_NAME	STRING	No	The organization name of an OpenSharing entity. The name will be used in Databricks-to-Databricks OpenSharing as the official name.
PRIVILEGE_MODEL_VERSION	STRING	No	Privilege model version.
CLOUD	STRING	No	Cloud vendor of the metastore.
REGION	STRING	No	Dataplane region that the metastore serves.
GLOBAL_METASTORE_ID	STRING	No	Globally unique metastore ID across clouds and regions. Used as OpenSharing sharing identifier.
CREATED	TIMESTAMP	No	Timestamp when the metastore was created.
CREATED_BY	STRING	No	Principal who created the metastore.
LAST_ALTERED	TIMESTAMP	No	Timestamp when the metastore was last altered in any way.
LAST_ALTERED_BY	STRING	No	Principal who last altered the metastore.

Name	Data type	Nullable	Description
METASTORE_ID	STRING	No	ID of the metastore.
METASTORE_NAME	STRING	No	Name of the metastore.
METASTORE_OWNER	STRING	No	Owner of the metastore.
STORAGE_ROOT	STRING	No	Storage root URL of the metastore.
STORAGE_ROOT_CREDENTIAL_ID	STRING	Yes	ID of the storage credential to access storage root.
STORAGE_ROOT_CREDENTIAL_NAME	STRING	Yes	Name of the storage credential to access storage root.
DELTA_SHARING_SCOPE	STRING	No	OpenSharing scope for the metastore.
DELTA_SHARING_RECIPIENT_TOKEN_LIFETIME	LONG	Yes	The lifetime of OpenSharing recipient tokens in seconds.
DELTA_SHARING_ORGANIZATION_NAME	STRING	No	The organization name of an OpenSharing entity. The name will be used in Databricks-to-Databricks OpenSharing as the official name.
PRIVILEGE_MODEL_VERSION	STRING	No	Privilege model version.
CLOUD	STRING	No	Cloud vendor of the metastore.
REGION	STRING	No	Dataplane region that the metastore serves.
GLOBAL_METASTORE_ID	STRING	No	Globally unique metastore ID across clouds and regions. Used as OpenSharing sharing identifier.
CREATED	TIMESTAMP	No	Timestamp when the metastore was created.
CREATED_BY	STRING	No	Principal who created the metastore.
LAST_ALTERED	TIMESTAMP	No	Timestamp when the metastore was last altered in any way.
LAST_ALTERED_BY	STRING	No	Principal who last altered the metastore.

Constraints

The following constraints apply to the METASTORES relation:

Class	Name	Column List	Description
Primary key	METASTORES_PK	METASTORE_ID, METASTORE_NAME	Unique identifier for the metastore.
Foreign key	METASTORES_CREDS_FK	STORAGE_ROOT_CREDENTIAL_ID, STORAGE_ROOT_CREDENTIAL_NAME	References STORAGE_CREDENTIALS

Class	Name	Column List	Description
Primary key	METASTORES_PK	METASTORE_ID, METASTORE_NAME	Unique identifier for the metastore.
Foreign key	METASTORES_CREDS_FK	STORAGE_ROOT_CREDENTIAL_ID, STORAGE_ROOT_CREDENTIAL_NAME	References STORAGE_CREDENTIALS

Examples

SQL

> SELECT metastore_owner
    FROM information_schema.metastores

Related

• Information schema
• INFORMATION_SCHEMA.METASTORE_PRIVILEGES