- Schema:
MULTI_
This Account Usage view provides the Multi-party Approval requests in your account, including who requested each protected operation, who approved or rejected it, and when.
Each row in this view corresponds to a different Multi-party Approval request.
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| REQUEST_ID | VARCHAR | Unique identifier for the approval request. |
| REQUESTER_USER_NAME | VARCHAR | Name of the user who triggered the request. |
| STATUS | VARCHAR | Status of the request, such as PENDING, APPROVED, REJECTED, CANCELLED, or EXPIRED. |
| OPERATION | VARCHAR | The protected operation that triggered the request, such as MODIFY_MULTI_PARTY_APPROVAL, DISABLE_MULTI_FACTOR_AUTHENTICATION, or MODIFY_NETWORK_POLICY. |
| JOB_UUID | VARCHAR | UUID of the job that triggered the request. |
| CREATED_TIME | TIMESTAMP_LTZ | Date and time when the request was created. |
| RESOLVED_TIME | TIMESTAMP_LTZ | Date and time when the request was resolved. NULL if the request is still pending. |
| EXPIRED_AT | TIMESTAMP_LTZ | Date and time when the request expires or expired. NULL if the request has not yet expired. |
| REQUEST_JUSTIFICATION | VARCHAR | Business justification provided by the requester. |
| JUSTIFICATION_TIME | TIMESTAMP_LTZ | Date and time when the justification was submitted. NULL if no justification was provided. |
| REQUIRED_APPROVALS_COUNT | NUMBER | Number of approvals required for this request. |
| APPROVERS | ARRAY | An array of objects, one per approver, each with the following keys:
|
| POLICY_ID | NUMBER | Internal/system-generated identifier for the Multi-party Approval policy that governs the request. |
| POLICY_NAME | VARCHAR | Fully qualified name (database.schema.policy) of the Multi-party Approval policy. NULL if the policy was dropped. |
Usage notes¶
- Latency for the view may be up to 120 minutes (2 hours).