How Does Stemma Calculate “Top 5 Columns”, “Frequent Users”, etc?

Estimated reading: 1 minute

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.