Schema:

ACCOUNT_USAGE

DATA_CLASSIFICATION_HISTORY view

This Account Usage view displays all historical sensitive data classification results for each table in the account. Unlike DATA_CLASSIFICATION_LATEST view, which shows only the most recent classification per table, this view shows all classification events over time, limited to the last 365 days.

Columns

Column nameData typeDescription
TABLE_IDNUMBERInternal/system-generated identifier for the table that was classified.
TABLE_NAMEVARCHARName of the table.
SCHEMA_IDNUMBERInternal/system-generated identifier for the schema that contains the table.
SCHEMA_NAMEVARCHARName of the schema that contains the table.
DATABASE_IDNUMBERInternal/system-generated identifier for the database that contains the table.
DATABASE_NAMEVARCHARName of the database that contains the table.
RESULTVARIANTClassification result at the time of classification. For a description of the JSON object, see the output of the SYSTEM$GET_CLASSIFICATION_RESULT function.
TRIGGER_TYPEVARCHARMode of the classification trigger: MANUAL or AUTO CLASSIFICATION, where MANUAL indicates that someone called a system function to initiate the classification process.
CLASSIFIED_ONTIMESTAMP_LTZTime when the classification was performed.
TABLE_DELETED_ONTIMESTAMP_LTZDate and time when the object or parent object was dropped. NULL if the object has not been deleted.

Usage notes

  • Latency for this view might be up to three hours.
  • Data is retained for 365 days (one year). Rows are removed only when a classification event is older than one year.
  • Unlike DATA_CLASSIFICATION_LATEST view, this view retains data for classification events even when the associated table, schema, or database is dropped. The TABLE_NAME, SCHEMA_NAME, and DATABASE_NAME columns reflect the table and its database/schema location recorded for that classification result, but do not preserve historical object names across subsequent rename operations. If a table is later moved to a different schema and reclassified, a new row reflects the new location. The TABLE_DELETED_ON column is non-null if the table has been dropped.

For more information on how to query this view, see Query the classification history.