BACKUP_POLICIES view¶

This Information Schema view provides information on backup policies.

Columns¶

Column name	Data type	Description
BACKUP_POLICY_NAME	VARCHAR	Name of the backup policy.
BACKUP_POLICY_SCHEMA	VARCHAR	Schema that the backup policy belongs to.
BACKUP_POLICY_CATALOG	VARCHAR	Database that the backup policy belongs to.
SCHEDULE	VARCHAR	Schedule for backup creation.
EXPIRE_AFTER_DAYS	NUMBER	Days after backup creation when backup should be expired and automatically deleted.
HAS_RETENTION_LOCK	VARCHAR	Indicates whether the policy includes a retention lock. Y if the policy has a retention lock; N otherwise. Retention lock protects backups from being deleted by anyone for the defined retention period. The retention lock also prevents the retention period from being decreased on the policy.
OWNER	VARCHAR	Name of the role that owns the backup policy.
OWNER_ROLE_TYPE	VARCHAR	Type of role that owns the backup policy. Account role or Database role.
CREATED	TIMESTAMP_LTZ	Date and time when the backup policy was created.
LAST_ALTERED	TIMESTAMP_LTZ	Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.
COMMENT	VARCHAR	Comment for the backup policy.

Latency for the view may be up to 180 minutes (3 hours).
The LAST_ALTERED column is updated when the following operations are performed on an object:
- DDL operations.
- DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
- Background maintenance operations on metadata performed by Snowflake.