DROP SNAPSHOT SET¶

Deletes a snapshot set.

另请参阅：: CREATE SNAPSHOT SET, ALTER SNAPSHOT SET, SHOW SNAPSHOT SETS

语法¶

DROP SNAPSHOT SET <name>

Copy

参数¶

name

Specifies the identifier for the snapshot set.

如果标识符包含空格或特殊字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。

有关更多信息，请参阅标识符要求。

访问控制要求¶

用于执行此操作的角色必须至少具有以下权限：

权限	对象	备注
OWNERSHIP	Snapshot set	The role used to modify the snapshot policy for a snapshot set must have the OWNERSHIP privilege on the set.

有关创建具有指定权限集的自定义角色的说明，请参阅创建自定义角色。

有关对安全对象执行 SQL 操作的相应角色和权限授予的一般信息，请参阅访问控制概述。

使用说明¶

重要

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.

示例¶

Delete the snapshot set t1_snapshots:

DROP SNAPSHOT SET t1_snapshots;

Copy