How Does Stemma Calculate “Top 5 Columns”, “Frequent Users”, etc?
The table details page in the Stemma UI provides usage information, derived as follows:
- To calculate the top five upstream and downstream columns, Stemma multiplies the number of unique users by the number of queries to get the ranking. The time frame is 30 days.
- To identify tables commonly usesd with this one, Stemma counts the joins that were part of any query in the past 90 days.
- To identify frequent users of a table, Stemma counts any user who has run a query on this table in the last 30 days.