Schema:

ORGANIZATION_USAGE

BACKUP_OPERATION_HISTORY view

This Organization Usage view provides information on operations performed on backups.

Columns

Organization-level columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization.
ACCOUNT_LOCATORVARCHARSystem-generated identifier for the account.
ACCOUNT_NAMEVARCHARUser-defined identifier for the account.

Additional 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 either 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).