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.