Account Usage: New and Changed Columns in Certain Views

Attention

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.

  • GRANTS_TO_ROLES view:

    • 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.

  • QUERY_HISTORY view:

    • New column, ROLE_TYPE, that displays ROLE or DATABASE_ROLE depending on whether the job was executed by an account-level or database role.

Ref: 732