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
orDATABASE_ROLE
. Note that Snowflake returns NULL if you delete the object because there is no owner role for a deleted object.This column will be added as the last column in the output.
Ref: 1294