Top Users by Page Visits¶
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;