SHOW commands for objects owned by an application: New column owner_role_type (Pending)

Attention

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 ALERTS

  • SHOW CLASSES

  • SHOW DATABASES

  • SHOW DYNAMIC TABLES

  • SHOW MATERIALIZED VIEWS

  • SHOW NETWORK RULES

  • SHOW SECRETS

  • SHOW STREAMLITS

  • SHOW WAREHOUSES

Before the change

The output of the command does not include the owner_role_type column.

After the change

The output of the command includes the owner_role_type column.

Column name

Description

owner_role_type

The type of role that owns the object: either ROLE and DATABASE_ROLE.

When the object is owned by a native app, the value is APPLICATION.

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.

Ref: 1274