- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
OBJECT_
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
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 allows consumers to access audit logs that track the submission, rejection, and approval of object access requests through the Internal Marketplace to maintain security and compliance.
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 |
|---|---|---|
| TIMESTAMP | TIMESTAMP_LTZ | The state transition event. |
| USER_REGION | VARCHAR | The region of the requester or approver. |
| USER_ACCOUNT_NAME | VARCHAR | The account name of the requester or approver. |
| USER_NAME | VARCHAR | The username of the requester or approver. |
| USER_EMAIL | VARCHAR | The email of the requester or approver. |
| USER_COMMENT | VARCHAR | For CREATE_REQUEST and CANCEL REQUEST, this shows the reason for access provided by the requester. For APPROVE_REQUEST, DENY_REQUEST, and AUTO_APPROVE_REQUEST, this is the comment for approval/denial provided by the approver. |
| ACTION | VARCHAR | The requester or approver action. This can be one of the following:
|
| REQUEST_ID | VARCHAR | The UUID of the request. This can be used to track the history of the request. |
| OBJECT_DOMAIN | VARCHAR | The requested object domain. Currently, this can only be DATA_EXCHANGE_LISTING. |
| OBJECT_REGION | VARCHAR | The snowflake region name where the requested object is located. |
| OBJECT_ACCOUNT_NAME | VARCHAR | The account where the requested object is located. |
| OBJECT_NAME | VARCHAR | The name of the requested object. |
| GRANTEE_TO_AUTHORIZE | VARCHAR | For CREATE_REQUEST and CANCEL REQUEST, this shows the role provided by the requester. For APPROVE_REQUEST, DENY_REQUEST, and AUTO_APPROVE_REQUEST, this is the role granted or denied by the approver. |
| GRANTEE_TYPE | VARCHAR | The type of the grantee. Currently, this can only be ROLE. |
Usage notes¶
- Latency for the view may be up to 5 hours.