ROLES view (Account Usage): New columns and new value for ROLE_TYPE column

Attention

This behavior change is in the 2023_06 bundle.

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

The Account Usage ROLES view in the shared SNOWFLAKE database behaves as follows:

Previously:

The ROLES view does not include the ROLE_ID and ROLE_INSTANCE_ID columns.

Additionally, the ROLE_TYPE column does not support INSTANCE_ROLE as a possible value.

Currently:

The output from a query on the ROLES view includes the ROLE_ID and ROLE_INSTANCE_ID columns.

Column

Data type

Description

Notes

ROLE_ID

NUMBER

Internal/system-generated identifier for the role.

This is the first ordinal column in the output.

ROLE_INSTANCE_ID

NUMBER

Internal/system-generated identifier for the class instance that the role belongs to.

This is the last ordinal column in the output.

Additionally, the ROLE_TYPE column includes a new value, INSTANCE_ROLE, to indicate that the role is associated with a particular class instance.

For details about classes, instances, and the associated roles, see Snowflake classes.

Ref: 1229 , 1240