Categories:

Database, Schema, & Share DDL

DROP SHARE

Snowflake logo in black (no text) Provider sharing not enabled for all accounts

Provider sharing is enabled by default for most, but not all accounts.

If you encounter errors when attempting to share data with consumers, the feature may not be enabled for your account. To inquire about enabling it, please contact Snowflake Support.

Removes the specified share from the system and immediately revokes access for all consumers (i.e. accounts who have created a database from the share).

See also:

CREATE SHARE , SHOW SHARES

Syntax

DROP SHARE <name>

Parameters

name

Specifies the identifier for the share to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage Notes

  • Only the ACCOUNTADMIN role has the privileges to drop a share. Executing this command with any role other than ACCOUNTADMIN returns an error.

  • Dropped shares cannot be recovered; they must be recreated.

  • Dropping a share does not affect the database in the share (or any of the objects in the database).

Important

Before dropping a share, consider the downstream impact of performing this operation:

  • Consumer accounts that have created databases from the share will no longer be able to query these databases.

  • Recreating a share with the same name as a previous share does not restore the databases created (by any consumers) from the share. Each consumer must create a new database from the new share.

  • A dropped share can not be restored. The share must be created again using the CREATE SHARE command and then configured using GRANT <privilege> … TO SHARE and ALTER SHARE.

Examples

DROP SHARE sales_s;

+-------------------------------+
| status                        |
|-------------------------------|
| SALES_S successfully dropped. |
+-------------------------------+