- Schema:
DATA_CLASSIFICATION_LATEST view¶
This Account 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¶
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. |
STATUS | VARCHAR | One of the following: |
TRIGGER_TYPE | VARCHAR | Mode of the classification trigger: |
LAST_CLASSIFIED_ON | TIMESTAMP_LTZ | Time when the table was classified. |
Usage notes¶
Latency for this view might be up to three 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.