EVENT_TABLES view¶
This Information Schema view displays a row for each event table and view in the specified (or current) database, including the views in the INFORMATION_SCHEMA schema itself.
- See also:
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
TABLE_CATALOG |
TEXT |
Database that the event table belongs to |
TABLE_SCHEMA |
TEXT |
Schema that the event table belongs to |
TABLE_NAME |
TEXT |
Name of the event table |
TABLE_OWNER |
TEXT |
Name of the role that owns the event table |
CREATED |
TIMESTAMP_LTZ |
Creation time of the event table |
LAST_ALTERED |
TIMESTAMP_LTZ |
Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes. |
COMMENT |
TEXT |
Comment for this event table |
Usage notes¶
The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed with a role that was granted the MANAGE GRANTS privilege.
This behavior also applies to other account-level privileges and Information Schema views for which there is a corresponding SHOW command.
The view does not include event tables that have been dropped. To view dropped tables, use SHOW EVENT TABLES instead.
To view only event tables in your queries, filter using a WHERE clause, e.g.:
... WHERE table_schema != 'INFORMATION_SCHEMA'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.
Examples¶
Retrieve the names of all event tables in all schemas in the mydatabase database:
SELECT TABLE_NAME
FROM mydatabase.information_schema.event_tables;