Data quality: DATA_METRIC_USER database role granted to the PUBLIC role¶

Users must use a role that has the SNOWFLAKE.DATA_METRIC_USER database role to work with system data metric functions (DMFs), which are used to set up data quality checks. This change affects which roles have the SNOWFLAKE.DATA_METRIC_USER database role by default.

Before the change:

By default, only the ACCOUNTADMIN role has the SNOWFLAKE.DATA_METRIC_USER database role. The account administrator must grant the database role to other roles to allow users to work with system DMFs.

After the change:

The PUBLIC role is granted the SNOWFLAKE.DATA_METRIC_USER database role, which means a user can use any role to work with system DMFs, including associating a system DMF with an object.

Ref: 2155