Schema:: ACCOUNT_USAGE

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: `CLASSIFIED` or `REVIEWED`.
TRIGGER_TYPE	VARCHAR	Mode of the classification trigger: `MANUAL`.
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.