CREATE SHARE
Applies to: Databricks SQL
Databricks Runtime 10.3 and above
Unity Catalog only
Creates a share with the specified name. If a share with the same name already exists, an exception is thrown.
To create and manage a share you must be a metastore administrator and Databricks SQL must be configured with the Unity Catalog metastore.
To add content to the share use ALTER SHARE
Parameters
-
The name of the share to be created.
IF NOT EXISTS
Creates a share with the given name if it does not exist. If a share with the same name already exists, nothing will happen.
comment
An optional
STRING
literal. The description for the share.
Examples
-- Create share `customer_share`. This throws exception if a share with name customer_share
-- already exists.
> CREATE SHARE customer_share;
-- Create share `customer_share` only if share with same name doesn't exist.
> CREATE SHARE IF NOT EXISTS customer_share;
-- Create share `customer_share` only if share with same name doesn't exist, with a comment.
> CREATE SHARE IF NOT EXISTS customer_share COMMENT 'This is customer share';