Schema:

ACCOUNT_USAGE

SNAPSHOT_OPERATION_HISTORY view — Deprecated

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

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