Account Usage views: Column updates to support the Snowflake Native App Framework¶

Attention

This behavior change is in the 2024_01 bundle.

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

The behavior of these Account Usage views and is as follows:

Before the change:

Regarding the owner_role_type column:

Some of the views do not include the column.
Some of the views include the column but:
- Do not include support for the application object by specifying APPLICATION as the owner object type.
- Are not consistent with how other Account Usage views specify the column.
In the GRANTS_TO_ROLES view:
- The grantee_name column specifies the name of the application object, and the granted_to column specifies APPLICATION.

After the change:

The changes to the views are grouped as follows:

The CLASSES and CLASS_INSTANCES views update the column to return the identifier of the role that owns the class or the instance of the class.
The following views already include the owner_role_type column and add support for APPLICATION as a possible value:
- FILE_FORMATS
- MASKING_POLICIES
- PIPES
- ROW_ACCESS_POLICIES
- SCHEMATA
- SEQUENCES
- SESSION_POLICIES
- STAGES
- TAGS
- VIEWS
The following views add the column as the last column in the view and add support for APPLICATION as a possible value:
- DATABASES
- PROCEDURES
- ROLES
The following views already include the role_type column and add support for APPLICATION as a possible value:
- AGGREGATE_QUERY_HISTORY
- QUERY_HISTORY
In the GRANTS_TO_ROLES view:
- The grantee_name column specifies the name of the application object and the granted_to column specifies APPLICATION.
- The granted_by column specifies the name of the application object when there are grants to application roles.
- The granted_by_role_type column specifies APPLICATION.

Ref: 1379