SHOW commands for objects owned by an application: New column
This behavior change is in the 2023_08 bundle.
For the current status of the bundle, refer to Bundle History.
The behavior of the following SHOW commands is as follows:
SHOW DYNAMIC TABLES
SHOW MATERIALIZED VIEWS
SHOW NETWORK RULES
- Before the change
The output of the command does not include the
- After the change
The output of the command includes the
The type of role that owns the object: either
When the object is owned by a native app, the value is
Snowflake returns NULL if you delete the object because there is no owner role for a deleted object, nor can a native app own a deleted object.