BACKUPS view¶

This Information Schema view provides information on backups.

Columns¶

Column name	Data type	Description
ID	VARCHAR	Snowflake-generated identifier of the backup. Note: this is not the local ID, this is the globally unique UUID of the backup.
CREATED	TIMESTAMP_LTZ	Timestamp at which backup was created.
BACKUP_SET_NAME	VARCHAR	Name of backup set that contains the backup.
BACKUP_SET_SCHEMA	VARCHAR	Name of schema that the backup set belongs to.
BACKUP_SET_CATALOG	VARCHAR	Name of database that the backup set belongs to.
EXPIRATION_SCHEDULED_FOR	TIMESTAMP_LTZ	Timestamp at which backup will be expired and deleted.
IS_UNDER_LEGAL_HOLD	BOOLEAN	Y if backup is under legal hold; N otherwise.