DESCRIBE SHARE

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only

Returns the metadata of an existing share. The metadata information includes share name, owner, and timestamps of creation and last modification.

To list the content of a share use SHOW ALL IN SHARE.

Syntax

[ DESC | DESCRIBE ] SHARE share_name

Parameters

• share_name

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

Examples

> CREATE SHARE vaccine COMMENT 'vaccine data to publish';
> DESCRIBE SHARE vaccine;
  name      created_at                   created_by                 comment
  --------- ---------------------------- -------------------------- -----------------------
  vaccine   2022-01-01T00:00:00.000+0000 alwaysworks@databricks.com vaccine data to publish

Related articles

• Change data feed

• CREATE SHARE

• ALTER SHARE

• DROP SHARE

• SHOW SHARES

• SHOW ALL IN SHARE

• COMMENT ON SHARE