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:

Setting up an Event Table, VIEWS View

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

    • 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;
Copy