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,
    	TYPE,
    	COUNT(*) AS USER_TYPE_COUNT
    FROM    
    	SNOWFLAKE.ACCOUNT_USAGE.USERS
    WHERE    
    	DELETED_ON IS NULL
    	AND LOGIN_NAME <>'SNOWFLAKE'
    GROUP BY
    	TYPE;

    This command

    • Returns a count of distinct Active Snowflake users

    • Filters out Inactive Snowflake users

    • Groups users by Type

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

    DetermineNumberUsers.png