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
|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.|
- 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.