- Schema:
BACKUP_OPERATION_HISTORY view¶
This Organization Usage view provides information on operations performed on backups.
Columns¶
Organization-level columns
Column Name |
Data Type |
Description |
|---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
ACCOUNT_LOCATOR |
VARCHAR |
System-generated identifier for the account. |
ACCOUNT_NAME |
VARCHAR |
User-defined identifier for the account. |
Additional columns
Column name |
Data type |
Description |
|---|---|---|
START_TIME |
TIMESTAMP_LTZ (or other type returned by TO_TIMESTAMP, depending on the value of the TIMESTAMP_TYPE_MAPPING parameter) |
The timestamp at which the backup operation started. |
END_TIME |
TIMESTAMP_LTZ |
The timestamp at which the backup operation ended. |
BACKUP_SET_ID |
NUMBER |
The local backup set ID. |
BACKUP_ID |
VARCHAR |
The unique identifier of backup being worked on. |
OPERATION_TYPE |
VARCHAR |
Could be either of the below operations:
|
QUERY_ID |
VARCHAR |
Internal system-generated identifier for the SQL statement. |
Usage notes¶
Latency for the view may be up to 360 minutes (6 hours).