DESCRIBE PROVIDER

  • Article

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 11.3 LTS and above check marked yes Unity Catalog only

Returns the metadata of a Delta Sharing provider.

Syntax

[ DESC | DESCRIBE ] PROVIDER provider_name

Parameters

  • provider_name

    The name of an existing provider. If the name does not exist, an exception is thrown.

    You must own the provider or be metastore administrator to describe it.

Examples

> DESCRIBE PROVIDER other_org;
 info_name             info_value
 -------------         ----------
 provider_name         other_org
 authentication_type   DATABRICKS
 created_by            alwaysworks@databricks.com
 create_at             2022-01-01T00:00:00.000+0000
 updated_by            alwayswork@databricks.com
 updated_at            2022-01-05T12:00:00.000+0000
 comment
 activated_by_provider true
 cloud                 azure
 region                chinaeast2
 metastore_id          f64dcb39-5046-4d4c-9588-c6ac84f9b38a