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 | Delta Sharing scope for the metastore. |
DELTA_SHARING_RECIPIENT_TOKEN_LIFETIME |
LONG |
Yes | The lifetime of Delta Sharing recipient tokens in seconds. |
DELTA_SHARING_ORGANIZATION_NAME |
STRING |
No | The organization name of a Delta Sharing entity. The name will be used in Databricks-to-Databricks Delta Sharing 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 Delta Sharing 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 |
Examples
> SELECT metastore_owner
FROM information_schema.metastores