Schema:

ORGANIZATION_USAGE

For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).

SNAPSHOT_OPERATION_HISTORY view — Deprecated

Organization Usage performance

When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in Performance (Organization Usage): bound every scan on history views, list columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.

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