- Schema:
SNAPSHOT_
This Organization Usage view provides information on snapshot sets.
Columns¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional columns
| Column name | Data type | Description |
|---|---|---|
| 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 | Date and time when the snapshot set was last altered. |
| DELETED | TIMESTAMP_LTZ | Date and time when the snapshot set was deleted. |
| COMMENT | VARCHAR | Comment for the snapshot set. |
Usage notes¶
- Latency for the view may be up to 180 minutes (3 hours).