Determine the Number of ALTR Licenses Needed for Snowflake

ALTR licenses are issued per Snowflake data user, so the number of ALTR user licenses you need depends on how many active users query your Snowflake account.

To determine how many ALTR user licenses you need:

1. Execute the following command in your Snowflake database using the ACCOUNTADMIN role, or a role granted IMPORTED PRIVILEGES on the SNOWFLAKE database (SYSADMIN does not have this access by default):

   SELECT
    CURRENT_ROLE() AS ROLE_USED,
    TYPE,
    COUNT(*) AS USER_TYPE_COUNT
   FROM
    SNOWFLAKE.ACCOUNT_USAGE.USERS
   WHERE
    DELETED_ON IS NULL
    AND LOGIN_NAME <>'SNOWFLAKE'
   GROUP BY
    TYPE;

   This excludes the built-in SNOWFLAKE user and any deleted users.

2. Review the USER_TYPE_COUNT column in the results to determine the number of ALTR user licenses your organization needs.