Control: Ensure an email address is specified for users with ACCOUNTADMIN role
Description
Snowflake recommendsto associate an actual person's email address to ACCOUNTADMIN users, so that Snowflake Support knows who to contact in an urgent situation.
Usage
Run the control in your terminal:
powerpipe control run snowflake_compliance.control.security_overview_iam_user_with_accountadmin_role_have_emailSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run snowflake_compliance.control.security_overview_iam_user_with_accountadmin_role_have_email --shareSQL
This control uses a named query:
iam_user_with_accountadmin_role_have_email