Skip to main content

metastore_summary

Creates, updates, deletes, gets or lists a metastore_summary resource.

Overview

Namemetastore_summary
TypeResource
Iddatabricks_workspace.catalog.metastore_summary

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringThe user-specified name of the metastore.
default_data_access_config_idstringUnique identifier of the metastore's (Default) Data Access Configuration.
global_metastore_idstringGlobally unique metastore ID across clouds and regions, of the form `cloud:region:metastore_id`.
metastore_idstringUnique identifier of metastore.
storage_root_credential_idstringUUID of storage credential to access the metastore storage_root.
delta_sharing_organization_namestringThe organization name of a Delta Sharing entity, to be used in Databricks-to-Databricks Delta Sharing as the official name.
storage_root_credential_namestringName of the storage credential to access the metastore storage_root.
cloudstring
created_atintegerTime at which this metastore was created, in epoch milliseconds.
created_bystringUsername of metastore creator.
delta_sharing_recipient_token_lifetime_in_secondsintegerThe lifetime of delta sharing recipient token in seconds.
delta_sharing_scopestringThe scope of Delta Sharing enabled for the metastore. (INTERNAL, INTERNAL_AND_EXTERNAL)
external_access_enabledbooleanWhether to allow non-DBR clients to directly access entities under the metastore.
ownerstringThe owner of the metastore.
privilege_model_versionstringPrivilege model version of the metastore, of the form `major.minor` (e.g., `1.0`).
regionstringCloud region which the metastore serves (e.g., `us-west-2`, `westus`).
storage_rootstringThe storage root URL for metastore
updated_atintegerTime at which the metastore was last modified, in epoch milliseconds.
updated_bystringUsername of user who last modified the metastore.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectdeployment_nameGets information about a metastore. This summary includes the storage credential, the cloud vendor,

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
deployment_namestringThe Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)

SELECT examples

Gets information about a metastore. This summary includes the storage credential, the cloud vendor,

SELECT
name,
default_data_access_config_id,
global_metastore_id,
metastore_id,
storage_root_credential_id,
delta_sharing_organization_name,
storage_root_credential_name,
cloud,
created_at,
created_by,
delta_sharing_recipient_token_lifetime_in_seconds,
delta_sharing_scope,
external_access_enabled,
owner,
privilege_model_version,
region,
storage_root,
updated_at,
updated_by
FROM databricks_workspace.catalog.metastore_summary
WHERE deployment_name = '{{ deployment_name }}' -- required
;