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:

Event table overview, VIEWS view

Columns

Column NameData TypeDescription
TABLE_CATALOGVARCHARDatabase that the event table belongs to
TABLE_SCHEMAVARCHARSchema that the event table belongs to
TABLE_NAMEVARCHARName of the event table
TABLE_OWNERVARCHARName of the role that owns the event table
CREATEDTIMESTAMP_LTZCreation time of the event table
LAST_ALTEREDTIMESTAMP_LTZDate and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.
COMMENTVARCHARComment 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;