Top Users by Page Visits

Note

This query is for Alation Analytics Version 1 (V1).

This query generates summary stats for the most active users of all time (based on most pages visited) inside of Alation.  Results from this query give the viewer a look at who is the most active historically in the Alation catalog.

SELECT
    COUNT(au.display_name), au.display_name
    FROM public.alation_visits AS av
    JOIN public.alation_user AS au
    ON au.user_id = av.user_id
    GROUP BY au.display_name
    ORDER BY count DESC;