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.

LAST_DDL

TIMESTAMP_LTZ

Timestamp of the last DDL operation performed on the table or view, including database refreshes for replication (if the refresh changes visible properties for the table/view).

LAST_DDL_BY

TEXT

Username of the user who performed the last DDL operation on the table or view.

DELETED

TIMESTAMP_LTZ

Date and time when the view was deleted.

COMMENT

TEXT

Comment for the view.

INSTANCE_ID

NUMBER

Internal/system-generated identifier for the instance which the object belongs to.

OWNER_ROLE_TYPE

TEXT

The type of role that owns the object, either ROLE or DATABASE_ROLE. Note that Snowflake returns NULL if you delete the object because there is no owner role for a deleted object.

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.