- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
DATA_
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 displays one row for the most recent result of a classified table for each classified table. Each row corresponds to a different table.
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 |
|---|---|---|
| TABLE_ID | NUMBER | Internal/system-generated identifier for the table that was classified. |
| TABLE_NAME | VARCHAR | Name of the table. |
| SCHEMA_ID | NUMBER | Internal/system-generated identifier for the schema that contains the table. |
| SCHEMA_NAME | VARCHAR | Name of the schema that contains the table. |
| DATABASE_ID | NUMBER | Internal/system-generated identifier for the database that contains the table. |
| DATABASE_NAME | VARCHAR | Name of the database that contains the table. |
| RESULT | VARIANT | Latest classification result. For a description of the JSON object, see the output of the SYSTEM$GET_CLASSIFICATION_RESULT function. |
| STATUS | VARCHAR | One of the following: CLASSIFIED or REVIEWED. |
| TRIGGER_TYPE | VARCHAR | Mode of the classification trigger: MANUAL or AUTO CLASSIFICATION, where MANUAL indicates that someone called a system function to initiate the classification process. |
| LAST_CLASSIFIED_ON | TIMESTAMP_LTZ | Time when the table was last successfully classified. |
| LAST_CLASSIFICATION_ATTEMPT | TIMESTAMP_LTZ | Timestamp of the last sensitive data classification attempt. If the value is greater than LAST_CLASSIFIED_ON, it indicates that the last sensitive data classification attempt resulted in a failure. |
| ERROR_MESSAGE | VARCHAR | Error message from the last sensitive data classification attempt, if it resulted in a failure. |
Usage notes¶
- Latency for the view may be up to 5 hours.
- This view retains data for as long as the table exists.
- A row in the view is removed when the following occur:
- A table is dropped or renamed.
- The table is reclassified.