Account Usage: New and Changed Columns in Certain Views¶
This behavior change is in the 2023_01 bundle.
For the current status of the bundle, refer to Bundle History.
To differentiate between account-level roles and database roles, the following changes have been made to the specified Account Usage views in the shared SNOWFLAKE database:
New column, OWNER_ROLE_TYPE, has been added to the following views:
The new column specifies the type of role (ROLE or DATABASE_ROLE) that owns the object.
Existing column, GRANTED_TO, now differentiates between ROLE and DATABASE_ROLE. Previously, it was always ROLE,
New column, GRANTED_BY_ROLE_TYPE, that displays ROLE or DATABASE_ROLE depending on whether the grantor is an account-level or database role.
New column, ROLE_TYPE, that displays ROLE or DATABASE_ROLE depending on whether the job was executed by an account-level or database role.