Account Metastore

View as Markdown

Get a metastoreGET /api/2.0/accounts/{account_id}/metastores/{metastore_id}Get all metastores associated with an accountGET /api/2.0/accounts/{account_id}/metastoresCreate MetastorePOST /api/2.0/accounts/{account_id}/metastoresUpdate a metastorePUT /api/2.0/accounts/{account_id}/metastores/{metastore_id}Delete a metastoreDELETE /api/2.0/accounts/{account_id}/metastores/{metastore_id}

MetastoreInfo object

namestring

The user-specified name of the metastore.

storage_rootstring

The storage root URL for metastore

default_data_access_config_idstringDeprecated

Unique identifier of the metastore's (Default) Data Access Configuration.

storage_root_credential_idstring

UUID of storage credential to access the metastore storage_root.

delta_sharing_scopestring

The scope of Delta Sharing enabled for the metastore.

Values:

• INTERNAL
• INTERNAL_AND_EXTERNAL

delta_sharing_recipient_token_lifetime_in_secondsint64

The lifetime of delta sharing recipient token in seconds.

delta_sharing_organization_namestring

The organization name of a Delta Sharing entity, to be used in Databricks-to-Databricks Delta Sharing as the official name.

ownerstring

The owner of the metastore.

privilege_model_versionstring

Privilege model version of the metastore, of the form major.minor (e.g., 1.0).

regionstring

Cloud region which the metastore serves (e.g., us-west-2, westus).

metastore_idstring

Unique identifier of metastore.

created_atint64

Time at which this metastore was created, in epoch milliseconds.

created_bystring

Username of metastore creator.

updated_atint64

Time at which the metastore was last modified, in epoch milliseconds.

updated_bystring

Username of user who last modified the metastore.

storage_root_credential_namestring

Name of the storage credential to access the metastore storage_root.

cloudstring

Cloud vendor of the metastore home shard (e.g., aws, azure, gcp).

global_metastore_idstring

Globally unique metastore ID across clouds and regions, of the form cloud:region:metastore_id.

external_access_enabledboolean

Whether to allow non-DBR clients to directly access entities under the metastore.

View as Markdown

The MetastoreInfo object

{
  "name": "string",
  "storage_root": "string",
  "default_data_access_config_id": "string",
  "storage_root_credential_id": "string",
  "delta_sharing_scope": "INTERNAL",
  "delta_sharing_recipient_token_lifetime_in_seconds": 0,
  "delta_sharing_organization_name": "string",
  "owner": "string",
  "privilege_model_version": "string",
  "region": "string",
  "metastore_id": "string",
  "created_at": 0,
  "created_by": "string",
  "updated_at": 0,
  "updated_by": "string",
  "storage_root_credential_name": "string",
  "cloud": "string",
  "global_metastore_id": "string",
  "external_access_enabled": true
}

Get a metastore GA

GET /api/2.0/accounts/{account_id}/metastores/{metastore_id}

Gets a Unity Catalog metastore from an account, both specified by ID.

API scopes: unity-catalog

Parameters

account_idstringuuidRequiredpath

<Databricks> account ID of any type. For non-E2 account types, get your account ID from the Accounts Console

metastore_idstringuuidRequiredpath

Unity Catalog metastore ID

Response

metastore_infoobject

Show child attributesHide child attributes

namestring

The user-specified name of the metastore.

storage_rootstring

The storage root URL for metastore

default_data_access_config_idstringDeprecated

Unique identifier of the metastore's (Default) Data Access Configuration.

storage_root_credential_idstring

UUID of storage credential to access the metastore storage_root.

delta_sharing_scopestring

The scope of Delta Sharing enabled for the metastore.

Values:

• INTERNAL
• INTERNAL_AND_EXTERNAL

delta_sharing_recipient_token_lifetime_in_secondsint64

The lifetime of delta sharing recipient token in seconds.

delta_sharing_organization_namestring

The organization name of a Delta Sharing entity, to be used in Databricks-to-Databricks Delta Sharing as the official name.

ownerstring

The owner of the metastore.

privilege_model_versionstring

Privilege model version of the metastore, of the form major.minor (e.g., 1.0).

regionstring

Cloud region which the metastore serves (e.g., us-west-2, westus).

metastore_idstring

Unique identifier of metastore.

created_atint64

Time at which this metastore was created, in epoch milliseconds.

created_bystring

Username of metastore creator.

updated_atint64

Time at which the metastore was last modified, in epoch milliseconds.

updated_bystring

Username of user who last modified the metastore.

storage_root_credential_namestring

Name of the storage credential to access the metastore storage_root.

cloudstring

Cloud vendor of the metastore home shard (e.g., aws, azure, gcp).

global_metastore_idstring

Globally unique metastore ID across clouds and regions, of the form cloud:region:metastore_id.

external_access_enabledboolean

Whether to allow non-DBR clients to directly access entities under the metastore.

View as Markdown

Response

{
  "metastore_info": {
    "name": "string",
    "storage_root": "string",
    "default_data_access_config_id": "string",
    "storage_root_credential_id": "string",
    "delta_sharing_scope": "INTERNAL",
    "delta_sharing_recipient_token_lifetime_in_seconds": 0,
    "delta_sharing_organization_name": "string",
    "owner": "string",
    "privilege_model_version": "string",
    "region": "string",
    "metastore_id": "string",
    "created_at": 0,
    "created_by": "string",
    "updated_at": 0,
    "updated_by": "string",
    "storage_root_credential_name": "string",
    "cloud": "string",
    "global_metastore_id": "string",
    "external_access_enabled": true
  }
}

Get all metastores associated with an account GA

GET /api/2.0/accounts/{account_id}/metastores

Gets all Unity Catalog metastores associated with an account specified by ID.

API scopes: unity-catalog

Parameters

account_idstringuuidRequiredpath

<Databricks> account ID of any type. For non-E2 account types, get your account ID from the Accounts Console

Response

Returns a list of MetastoreInfo objects.

View as Markdown

Response

{
  "metastores": [
    {
      "name": "string",
      "storage_root": "string",
      "default_data_access_config_id": "string",
      "storage_root_credential_id": "string",
      "delta_sharing_scope": "INTERNAL",
      "delta_sharing_recipient_token_lifetime_in_seconds": 0,
      "delta_sharing_organization_name": "string",
      "owner": "string",
      "privilege_model_version": "string",
      "region": "string",
      "metastore_id": "string",
      "created_at": 0,
      "created_by": "string",
      "updated_at": 0,
      "updated_by": "string",
      "storage_root_credential_name": "string",
      "cloud": "string",
      "global_metastore_id": "string",
      "external_access_enabled": true
    }
  ]
}

Create Metastore GA

POST /api/2.0/accounts/{account_id}/metastores

Creates a Unity Catalog metastore.

API scopes: unity-catalog

Parameters

account_idstringuuidRequiredpath

<Databricks> account ID of any type. For non-E2 account types, get your account ID from the Accounts Console

Request body

metastore_infoobject

Show child attributesHide child attributes

namestring

The user-specified name of the metastore.

storage_rootstring

The storage root URL for metastore

default_data_access_config_idstringDeprecated

Unique identifier of the metastore's (Default) Data Access Configuration.

storage_root_credential_idstring

UUID of storage credential to access the metastore storage_root.

delta_sharing_scopestring

The scope of Delta Sharing enabled for the metastore.

Values:

• INTERNAL
• INTERNAL_AND_EXTERNAL

delta_sharing_recipient_token_lifetime_in_secondsint64

The lifetime of delta sharing recipient token in seconds.

delta_sharing_organization_namestring

The organization name of a Delta Sharing entity, to be used in Databricks-to-Databricks Delta Sharing as the official name.

ownerstring

The owner of the metastore.

privilege_model_versionstring

Privilege model version of the metastore, of the form major.minor (e.g., 1.0).

regionstring

Cloud region which the metastore serves (e.g., us-west-2, westus).

metastore_idstring

Unique identifier of metastore.

created_atint64

Time at which this metastore was created, in epoch milliseconds.

created_bystring

Username of metastore creator.

updated_atint64

Time at which the metastore was last modified, in epoch milliseconds.

updated_bystring

Username of user who last modified the metastore.

storage_root_credential_namestring

Name of the storage credential to access the metastore storage_root.

cloudstring

Cloud vendor of the metastore home shard (e.g., aws, azure, gcp).

global_metastore_idstring

Globally unique metastore ID across clouds and regions, of the form cloud:region:metastore_id.

external_access_enabledboolean

Whether to allow non-DBR clients to directly access entities under the metastore.

Response

metastore_infoobject

Show child attributesHide child attributes

namestring

The user-specified name of the metastore.

storage_rootstring

The storage root URL for metastore

default_data_access_config_idstringDeprecated

Unique identifier of the metastore's (Default) Data Access Configuration.

storage_root_credential_idstring

UUID of storage credential to access the metastore storage_root.

delta_sharing_scopestring

The scope of Delta Sharing enabled for the metastore.

Values:

• INTERNAL
• INTERNAL_AND_EXTERNAL

delta_sharing_recipient_token_lifetime_in_secondsint64

The lifetime of delta sharing recipient token in seconds.

delta_sharing_organization_namestring

The organization name of a Delta Sharing entity, to be used in Databricks-to-Databricks Delta Sharing as the official name.

ownerstring

The owner of the metastore.

privilege_model_versionstring

Privilege model version of the metastore, of the form major.minor (e.g., 1.0).

regionstring

Cloud region which the metastore serves (e.g., us-west-2, westus).

metastore_idstring

Unique identifier of metastore.

created_atint64

Time at which this metastore was created, in epoch milliseconds.

created_bystring

Username of metastore creator.

updated_atint64

Time at which the metastore was last modified, in epoch milliseconds.

updated_bystring

Username of user who last modified the metastore.

storage_root_credential_namestring

Name of the storage credential to access the metastore storage_root.

cloudstring

Cloud vendor of the metastore home shard (e.g., aws, azure, gcp).

global_metastore_idstring

Globally unique metastore ID across clouds and regions, of the form cloud:region:metastore_id.

external_access_enabledboolean

Whether to allow non-DBR clients to directly access entities under the metastore.

View as Markdown

Request

{
  "metastore_info": {
    "name": "string",
    "storage_root": "string",
    "default_data_access_config_id": "string",
    "storage_root_credential_id": "string",
    "delta_sharing_scope": "INTERNAL",
    "delta_sharing_recipient_token_lifetime_in_seconds": 0,
    "delta_sharing_organization_name": "string",
    "owner": "string",
    "privilege_model_version": "string",
    "region": "string",
    "metastore_id": "string",
    "created_at": 0,
    "created_by": "string",
    "updated_at": 0,
    "updated_by": "string",
    "storage_root_credential_name": "string",
    "cloud": "string",
    "global_metastore_id": "string",
    "external_access_enabled": true
  }
}

Response

{
  "metastore_info": {
    "name": "string",
    "storage_root": "string",
    "default_data_access_config_id": "string",
    "storage_root_credential_id": "string",
    "delta_sharing_scope": "INTERNAL",
    "delta_sharing_recipient_token_lifetime_in_seconds": 0,
    "delta_sharing_organization_name": "string",
    "owner": "string",
    "privilege_model_version": "string",
    "region": "string",
    "metastore_id": "string",
    "created_at": 0,
    "created_by": "string",
    "updated_at": 0,
    "updated_by": "string",
    "storage_root_credential_name": "string",
    "cloud": "string",
    "global_metastore_id": "string",
    "external_access_enabled": true
  }
}

Update a metastore GA

PUT /api/2.0/accounts/{account_id}/metastores/{metastore_id}

Updates an existing Unity Catalog metastore.

API scopes: unity-catalog

Parameters

account_idstringuuidRequiredpath

<Databricks> account ID of any type. For non-E2 account types, get your account ID from the Accounts Console

metastore_idstringuuidRequiredpath

Unity Catalog metastore ID

Request body

metastore_infoobject

Properties of the metastore to change.

Show child attributesHide child attributes

namestring

The user-specified name of the metastore.

storage_rootstring

The storage root URL for metastore

default_data_access_config_idstringDeprecated

Unique identifier of the metastore's (Default) Data Access Configuration.

storage_root_credential_idstring

UUID of storage credential to access the metastore storage_root.

delta_sharing_scopestring

The scope of Delta Sharing enabled for the metastore.

Values:

• INTERNAL
• INTERNAL_AND_EXTERNAL

delta_sharing_recipient_token_lifetime_in_secondsint64

The lifetime of delta sharing recipient token in seconds.

delta_sharing_organization_namestring

The organization name of a Delta Sharing entity, to be used in Databricks-to-Databricks Delta Sharing as the official name.

ownerstring

The owner of the metastore.

privilege_model_versionstring

Privilege model version of the metastore, of the form major.minor (e.g., 1.0).

regionstring

Cloud region which the metastore serves (e.g., us-west-2, westus).

metastore_idstring

Unique identifier of metastore.

created_atint64

Time at which this metastore was created, in epoch milliseconds.

created_bystring

Username of metastore creator.

updated_atint64

Time at which the metastore was last modified, in epoch milliseconds.

updated_bystring

Username of user who last modified the metastore.

storage_root_credential_namestring

Name of the storage credential to access the metastore storage_root.

cloudstring

Cloud vendor of the metastore home shard (e.g., aws, azure, gcp).

global_metastore_idstring

Globally unique metastore ID across clouds and regions, of the form cloud:region:metastore_id.

external_access_enabledboolean

Whether to allow non-DBR clients to directly access entities under the metastore.

Response

metastore_infoobject

Show child attributesHide child attributes

namestring

The user-specified name of the metastore.

storage_rootstring

The storage root URL for metastore

default_data_access_config_idstringDeprecated

Unique identifier of the metastore's (Default) Data Access Configuration.

storage_root_credential_idstring

UUID of storage credential to access the metastore storage_root.

delta_sharing_scopestring

The scope of Delta Sharing enabled for the metastore.

Values:

• INTERNAL
• INTERNAL_AND_EXTERNAL

delta_sharing_recipient_token_lifetime_in_secondsint64

The lifetime of delta sharing recipient token in seconds.

delta_sharing_organization_namestring

The organization name of a Delta Sharing entity, to be used in Databricks-to-Databricks Delta Sharing as the official name.

ownerstring

The owner of the metastore.

privilege_model_versionstring

Privilege model version of the metastore, of the form major.minor (e.g., 1.0).

regionstring

Cloud region which the metastore serves (e.g., us-west-2, westus).

metastore_idstring

Unique identifier of metastore.

created_atint64

Time at which this metastore was created, in epoch milliseconds.

created_bystring

Username of metastore creator.

updated_atint64

Time at which the metastore was last modified, in epoch milliseconds.

updated_bystring

Username of user who last modified the metastore.

storage_root_credential_namestring

Name of the storage credential to access the metastore storage_root.

cloudstring

Cloud vendor of the metastore home shard (e.g., aws, azure, gcp).

global_metastore_idstring

Globally unique metastore ID across clouds and regions, of the form cloud:region:metastore_id.

external_access_enabledboolean

Whether to allow non-DBR clients to directly access entities under the metastore.

View as Markdown

Request

{
  "metastore_info": {
    "name": "string",
    "storage_root": "string",
    "default_data_access_config_id": "string",
    "storage_root_credential_id": "string",
    "delta_sharing_scope": "INTERNAL",
    "delta_sharing_recipient_token_lifetime_in_seconds": 0,
    "delta_sharing_organization_name": "string",
    "owner": "string",
    "privilege_model_version": "string",
    "region": "string",
    "metastore_id": "string",
    "created_at": 0,
    "created_by": "string",
    "updated_at": 0,
    "updated_by": "string",
    "storage_root_credential_name": "string",
    "cloud": "string",
    "global_metastore_id": "string",
    "external_access_enabled": true
  }
}

Response

{
  "metastore_info": {
    "name": "string",
    "storage_root": "string",
    "default_data_access_config_id": "string",
    "storage_root_credential_id": "string",
    "delta_sharing_scope": "INTERNAL",
    "delta_sharing_recipient_token_lifetime_in_seconds": 0,
    "delta_sharing_organization_name": "string",
    "owner": "string",
    "privilege_model_version": "string",
    "region": "string",
    "metastore_id": "string",
    "created_at": 0,
    "created_by": "string",
    "updated_at": 0,
    "updated_by": "string",
    "storage_root_credential_name": "string",
    "cloud": "string",
    "global_metastore_id": "string",
    "external_access_enabled": true
  }
}

Delete a metastore GA

DELETE /api/2.0/accounts/{account_id}/metastores/{metastore_id}

Deletes a Unity Catalog metastore for an account, both specified by ID.

API scopes: unity-catalog

Parameters

account_idstringuuidRequiredpath

<Databricks> account ID of any type. For non-E2 account types, get your account ID from the Accounts Console

metastore_idstringuuidRequiredpath

Unity Catalog metastore ID

forcebooleanquery

Force deletion even if the metastore is not empty. Default is false.

View as Markdown

Response

{}