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