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 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

Classification result at the time of classification. For a description of the JSON object, see the output of the SYSTEM$GET_CLASSIFICATION_RESULT function.

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.

CLASSIFIED_ON

TIMESTAMP_LTZ

Time when the classification was performed.

TABLE_DELETED_ON

TIMESTAMP_LTZ

Date 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.