Schema:

ACCOUNT_USAGE

BACKUP_OPERATION_HISTORY view

This Account Usage view provides information about the backup operations that were performed for backup sets. Snowflake returns one row for each operation performed on backups within backup sets over the last year.

Columns

Column nameData typeDescription
START_TIMETIMESTAMP_LTZThe timestamp at which the backup operation started.
END_TIMETIMESTAMP_LTZThe timestamp at which the backup operation ended.
BACKUP_SET_IDNUMBERThe local backup set ID.
BACKUP_IDVARCHARThe unique identifier of backup being worked on.
OPERATION_TYPEVARCHAR

Could be one of the below operations:

  • CREATE
  • EXPIRE
  • RESTORE
  • ADD_LEGAL_HOLD
  • REMOVE_LEGAL_HOLD
Query_IDVARCHARInternal system-generated identifier for the SQL statement.

Usage notes

  • Latency for the view may be up to 360 minutes (6 hours).
  • Snowflake retains the history data for 365 days (approximately one year).