TABLES views (Account Usage and Information Schema): TABLE_TYPE column value shows correct value for event tables

Attention

This behavior change is in the 2023_06 bundle.

For the current status of the bundle, refer to Bundle History.

In the current Snowflake release, in the Account Usage schema TABLES view and Information schema TABLES view, the TABLE_TYPE column value have changed for certain rows. When the table described in the view row is an event table, the TABLE_TYPE column value will be EVENT TABLE.

Previously:

When the TABLES view row describes an event table, the row’s TABLE_TYPE column value is null.

Currently:

When the TABLES view row describes an event table, the row’s TABLE_TYPE column value is EVENT TABLE.

Ref: 1169

Language: English