Schema:

ORGANIZATION_USAGE

SNAPSHOT_OPERATION_HISTORY view — Deprecated

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

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 snapshot operation started.
END_TIMETIMESTAMP_LTZThe timestamp at which the snapshot operation ended.
SNAPSHOT_SET_IDNUMBERThe local snapshot set ID.
SNAPSHOT_IDVARCHARThe unique identifier of snapshot 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).