SHOW Commands: New OWNER_ROLE_TYPE Column in Output

Attention

This behavior change is in the 2023_04 bundle.

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

The OWNER_ROLE_TYPE column is included in the output of the following SHOW <object_type> commands:

  • SHOW EXTERNAL TABLES

  • SHOW FILE FORMATS

  • SHOW MASKING POLICIES

  • SHOW MATERIALIZED VIEWS

  • SHOW OBJECTS

  • SHOW PIPES

  • SHOW ROW ACCESS POLICIES

  • SHOW SCHEMAS

  • SHOW SEQUENCES

  • SHOW STAGES

  • SHOW STREAMS

  • SHOW TABLES

  • SHOW TAGS

  • SHOW TASKS

  • SHOW VIEWS

The column displays the type of role that owns the object: ROLE or DATABASE_ROLE.

Ref: 747