DROP SNAPSHOT SET¶

Deletes a snapshot set.

See also:: CREATE SNAPSHOT SET, ALTER SNAPSHOT SET, SHOW SNAPSHOT SETS

Syntax¶

DROP SNAPSHOT SET <name>

Copy

Parameters¶

name

Specifies the identifier for the snapshot set.

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

For more information, see Identifier requirements.

Access control requirements¶

A role used to execute this operation must have the following privileges at a minimum:

Privilege	Object	Notes
OWNERSHIP	Snapshot set	The role used to modify the snapshot policy for a snapshot set must have the OWNERSHIP privilege on the set.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes¶

Important

If the snapshot policy has a retention lock applied to it, and there are any unexpired snapshots in the snapshot set, then you can’t delete the snapshot set. In that case, you must wait for all the snapshots in the set to expire. This restriction applies even to privileged roles such as ACCOUNTADMIN, and to Snowflake support. For that reason, be careful when specifying retention lock and a long expiration period in a snapshot policy.

Examples¶

Delete the snapshot set t1_snapshots:

DROP SNAPSHOT SET t1_snapshots;

Copy