Skip to main content

Determine Number of Users Needed

Our licenses are issued per Snowflake data user. If you need help figuring out how many ALTR user licenses you need, run a simple command to determine the number of ALTR users based on the number of Snowflake data users to make a well-informed decision about your plan.

To determine how many ALTR user licenses you need:

  1. Execute the following command in your Snowflake database using the ACCOUNTADMIN or the SYSADMIN role:

    SELECT    
    CURRENT_ROLE() AS ROLE_USED,
    COUNT(DISTINCT LOGIN_NAME) AS ALTR_USER_COUNT
FROM    
    SNOWFLAKE.ACCOUNT_USAGE.USERS
WHERE    
    DISABLED = 'false'
    AND DELETED_ON IS NULL
    AND LOGIN_NAME <>'SNOWFLAKE';

    This command

    • Returns distinct Active Snowflake users

    • Filters out Inactive Snowflake users

  2. View the count in the ALTR_USER_COUNT column to determine the number of ALTR users needed for your company.

    DeterminNumOfUsers.png
In this section: