SHOW EVENT TABLES command: Add owner_role_type column

Attention

This behavior change is in the 2023_07 bundle.

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

The SHOW EVENT TABLES command behaves as follows:

Before the change:

The output of the SHOW EVENT TABLES command does not include an OWNER_ROLE_TYPE column.

After the change:

The output of the SHOW EVENT TABLES command includes the OWNER_ROLE_TYPE column, which is defined as follows:

Column Name

Data type

Description

owner_role_type

String

The type of role that owns the object, either ROLE or DATABASE_ROLE. . If a Snowflake Native App owns the object, the value is APPLICATION. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

This column will be added as the last column in the output.

Ref: 1294