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