- Schema:
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:
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. |
OWNER_ROLE_TYPE |
TEXT |
The type of role that owns the object, either |
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.