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