Schema:

ACCOUNT_USAGE

VIEWS view

This Account Usage view displays a row for each view in the account, not including the views in the ACCOUNT_USAGE, READER_ACCOUNT_USAGE, and INFORMATION_SCHEMA schemas.

See also:

TABLES view

Columns

Column NameData TypeDescription
TABLE_IDNUMBERInternal/system-generated identifier for the view.
TABLE_NAMEVARCHARName of the view.
TABLE_SCHEMA_IDNUMBERInternal/system-generated identifier for the schema that the view belongs to.
TABLE_SCHEMAVARCHARSchema that the view belongs to.
TABLE_CATALOG_IDNUMBERInternal/system-generated identifier for the database that the view belongs to.
TABLE_CATALOGVARCHARDatabase that the view belongs to.
TABLE_OWNERVARCHARName of the role that owns the view.
VIEW_DEFINITIONVARCHARText of the query expression for the view.
CHECK_OPTIONVARCHARNot applicable for Snowflake.
IS_UPDATABLEVARCHARNot applicable for Snowflake.
INSERTABLE_INTOVARCHARNot applicable for Snowflake.
IS_SECUREVARCHARSpecifies whether the view is secure.
CREATEDTIMESTAMP_LTZDate and time when the view was created.
LAST_ALTEREDTIMESTAMP_LTZDate and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.
LAST_DDLTIMESTAMP_LTZ

Timestamp of the last DDL operation performed on the table or view.

All supported table/view DDL operations update this field:

  • { CREATE | ALTER | DROP | UNDROP } TABLE
  • { CREATE | ALTER | DROP } VIEW

All ALTER TABLE operations update this field, including setting or unsetting a table parameter (for example, COMMENT, DATA_RETENTION_TIME, etc.) and changes to table columns (ADD / MODIFY / RENAME / DROP).

For more information, see the Usage Notes.

LAST_DDL_BYVARCHAR

The current username for the user who executed the last DDL operation. If the user has been dropped, shows DROPPED_USER(<id>).

For dropped users, you can join the <id> with the USER_ID column in the USERS view of the ACCOUNT_USAGE or ORGANIZATION_USAGE schema.

DELETEDTIMESTAMP_LTZDate and time when the view was deleted.
COMMENTVARCHARComment for the view.
INSTANCE_IDNUMBERInternal/system-generated identifier for the instance which the object belongs to.
OWNER_ROLE_TYPEVARCHARThe type of role that owns the object, for example ROLE.
If a Snowflake Native App owns the object, the value is APPLICATION.
Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

Usage notes

  • Latency for the view may be up to 90 minutes.
  • The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.

  • The LAST_ALTERED column is updated when the following operations are performed on an object:

    • DDL operations.
    • DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
    • Background maintenance operations on metadata performed by Snowflake.

    For views and tables, use the LAST_DDL column for the last modification time for an object.

  • The value in the LAST_DDL column is updated as follows:

    • When a table or view is created, the LAST_DDL timestamp is the same as the CREATED timestamp.
    • When a table or view is dropped, the LAST_DDL timestamp is the same as the DELETED timestamp.
    • Last DDL data is not available for operations that occurred before the columns were added. The new DDL fields contain null until a DDL operation is executed.
    • For replicated databases, the LAST_DDL and LAST_DDL_BY fields are only updated for objects in the primary database. After failover, the LAST_DDL and LAST_DDL_BY fields are updated for DDL operations for the tables and views in the newly promoted primary database. These fields will remain unchanged for objects in the now secondary database.
    • For objects in secondary databases that are newly created during a refresh operation, these fields are null.