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 Name Data Type Description
TABLE_ID NUMBER Internal/system-generated identifier for the view.
TABLE_NAME TEXT Name of the view.
TABLE_SCHEMA_ID NUMBER Internal/system-generated identifier for the schema that the view belongs to.
TABLE_SCHEMA TEXT Schema that the view belongs to.
TABLE_CATALOG_ID NUMBER Internal/system-generated identifier for the database that the view belongs to.
TABLE_CATALOG TEXT Database that the view belongs to.
TABLE_OWNER TEXT Name of the role that owns the view.
VIEW_DEFINITION TEXT Text of the query expression for the view.
CHECK_OPTION TEXT Not applicable for Snowflake.
IS_UPDATABLE TEXT Not applicable for Snowflake.
INSERTABLE_INTO TEXT Not applicable for Snowflake.
IS_SECURE TEXT Specifies whether the view is secure.
CREATED TIMESTAMP_LTZ Date and time when the view was created.
LAST_ALTERED TIMESTAMP_LTZ Date and time when the view was last altered.
DELETED TIMESTAMP_LTZ Date and time when the view was deleted.
COMMENT TEXT Comment for the view.

Usage Notes

  • Latency for the view may be up to 90 minutes.
  • The view only displays objects for which the current role for the session has been granted access privileges.
  • 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.