Food for thought:
In my experience the biggest issue isn’t “where can I found a query about X”, but rather “where can I find a query about X that is still being maintained and therefore trustworthy, without having to ask the data people every time”.
To address this issue at my last job I made a very dumb solution, which actually worked pretty well. (We used Tableau, but it looks like this can be done easily in Redash too, using the events table - perhaps this is what’s meant by “queries PV” in the post above.) I created a master dashboard with a horizontal bar graph where the Y axis was a list of all dashboards (not queries, but rather dashboards of a given concept, each containing multiple queries that slice and dice that concept in different ways) and the X axis was how many times they had been viewed in the last 30 days. People knew that we were actively monitoring and maintaining anything in the top 15 or so and these could be relied upon as the source of truth (as well as anything else that we hand-delivered recently). It also served as a great form of feedback for us data people to understand what was being used and what wasn’t, ensuring we prioritized our time on what people truly cared about.
We did categorize these dashboards but that didn’t end up being so useful because it was easy enough to scan through 15 titles and that covered most of our core concepts anyway. The one category that did prove useful though was “One-off”, because that indicated the result was valid only as of the date listed.
We also did a clean up where we archived dashboards that were no longer relevant, every month or two. I suspect this is possible for many organizations at the dashboard level, but it will not be feasible to keep every query pristine.
Hope this context is useful to the ideation here! Thanks for all you do, I love redash!