Schema:: ORGANIZATION_USAGE

SNAPSHOTS view — Deprecated¶

This Organization Usage view provides information on snapshots.

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	VARCHAR	Snowflake-generated identifier of the snapshot. Note: this is not the local ID, this is the globally unique UUID of the Snapshot.
SNAPSHOT_SET_ID	NUMBER	ID of snapshot set that contains the snapshot.
SNAPSHOT_SET_NAME	VARCHAR	Name of snapshot set that contains the snapshot.
SNAPSHOT_SET_SCHEMA_ID	NUMBER	ID of schema that the snapshot set belongs to.
SNAPSHOT_SET_SCHEMA	VARCHAR	Name of schema that the snapshot set belongs to.
SNAPSHOT_SET_CATALOG_ID	NUMBER	ID of database that the snapshot set belongs to.
SNAPSHOT_SET_CATALOG	VARCHAR	Name of database that the snapshot set belongs to.
CREATED	TIMESTAMP_LTZ	Timestamp at which snapshot was created.
DELETED	TIMESTAMP_LTZ	Timestamp at which snapshot was deleted.
EXPIRATION_SCHEDULED_FOR	TIMESTAMP_LTZ	Timestamp at which snapshot will be expired.
IS_UNDER_LEGAL_HOLD	BOOLEAN	Y if snapshot is under legal hold; N otherwise. This column isn’t displayed by the SHOW command, because the SHOW command output doesn’t include deleted objects.

Usage notes¶

Latency for the view may be up to 180 minutes (3 hours).