SNAPSHOT_SETS view¶
This Account Usage view provides information about snapshot sets and their properties.
列¶
列名称 |
数据类型 |
描述 |
|---|---|---|
ID |
NUMBER |
Internal system-generated identifier for the snapshot set. |
NAME |
VARCHAR |
Name of the snapshot set |
SCHEMA_ID |
NUMBER |
Internal system-generated identifier for the schema of the snapshot set. |
SCHEMA_NAME |
VARCHAR |
Schema that the snapshot set belongs to |
CATALOG_ID |
NUMBER |
Internal system-generated identifier for the database of the snapshot set. |
CATALOG_NAME |
VARCHAR |
Database that the snapshot set belongs to. |
OBJECT_KIND |
VARCHAR |
Type of object that the snapshot set is snapshotting. |
OBJECT_ID |
NUMBER |
ID of object that the snapshot set is snapshotting. |
OBJECT_NAME |
VARCHAR |
Name of object that the snapshot set is snapshotting. |
OBJECT_SCHEMA_ID |
NUMBER |
ID of schema that contains the object being snapshotted by this snapshot set. |
OBJECT_SCHEMA_NAME |
VARCHAR |
Name of schema that contains the object being snapshotted by this snapshot set. |
OBJECT_CATALOG_ID |
NUMBER |
ID of database that contains the object being snapshotted by this snapshot set. |
OBJECT_CATALOG_NAME |
VARCHAR |
Name of database that contains the object being snapshotted by this snapshot set. |
SNAPSHOT_POLICY_ID |
NUMBER |
ID of snapshot policy attached to this snapshot set. |
SNAPSHOT_POLICY_NAME |
VARCHAR |
Name of snapshot policy attached to this snapshot set. |
SNAPSHOT_POLICY_SCHEMA_ID |
NUMBER |
ID of the schema that contains the snapshot policy. |
SNAPSHOT_POLICY_SCHEMA_NAME |
VARCHAR |
Name of the schema that contains the snapshot policy. |
SNAPSHOT_POLICY_CATALOG_ID |
NUMBER |
ID of the database that contains the snapshot policy. |
SNAPSHOT_POLICY_CATALOG_NAME |
VARCHAR |
Name of the database that contains the snapshot policy. |
OWNER |
VARCHAR |
Name of the role that owns the snapshot set. |
OWNER_ROLE_TYPE |
VARCHAR |
Type of role that owns the snapshot set. Account role or Database role. |
CREATED |
TIMESTAMP_LTZ |
Date and time when the snapshot set was created. |
LAST_ALTERED |
TIMESTAMP_LTZ |
对象上次经 DML、DDL 或后台元数据操作修改的日期和时间。请参阅 使用说明。 |
DELETED |
TIMESTAMP_LTZ |
Date and time when the snapshot set was deleted. |
COMMENT |
VARCHAR |
Comment for the snapshot set. |
使用说明¶
Latency for the view may be up to 360 minutes (6 hours).
对对象执行以下操作时，将更新 LAST_ALTERED 列：
DDL 操作。
DML 操作（仅适用于表）。即使 DML 语句不影响任何行，也会更新此列。
由 Snowflake 对元数据执行的后台维护操作。