BLOCK_STORAGE_SNAPSHOTS view¶

This Account Usage view displays a row for each block storage snapshot in the account.

Columns¶

Column Name	Data Type	Description
SNAPSHOT_ID	NUMBER	ID of the snapshot.
SNAPSHOT_NAME	VARCHAR	Name of the snapshot.
DATABASE_ID	VARCHAR	Internal, Snowflake-generated identifier of the database that the snapshot belongs to.
DATABASE_NAME	VARCHAR	Name of the database that the snapshot belongs to.
SCHEMA_ID	NUMBER	Internal, Snowflake-generated identifier of the schema that the snapshot belongs to.
SCHEMA_NAME	VARCHAR	Name of the schema that the snapshot belongs to.
SERVICE_ID	NUMBER	ID of the service for which the snapshot is created.
SERVICE_NAME	VARCHAR	Name of the service for which the snapshot is created.
VOLUME _NAME	VARCHAR	Volume from the specified service for which the snapshot is created.
INSTANCE	NUMBER	ID of the service instance for which the snapshot is created.
SIZE	NUMBER	Size in GB of the snapshot.
ENCRYPTION	VARCHAR	Encryption type of the volume from which the snapshot was created.
COMMENT	VARCHAR	General comment about the snapshot.
OWNER	VARCHAR	Role that owns the snapshot.
OWNER_ROLE_TYPE	VARCHAR	The type of role that owns the snapshot.
CREATED_ON	TIMESTAMP_LTZ	Creation time of the snapshot.
LAST_ALTERED_ON	TIMESTAMP_LTZ	Last altered time of the snapshot.
DELETED_ON	TIMESTAMP_LTZ	Deletion time of the snapshot.

SELECT *
FROM SNOWFLAKE.ACCOUNT_USAGE.BLOCK_STORAGE_SNAPSHOTS;

Copy