Existing tools to find unused tables in cassandra cluster

Question

We've bunch of prod and non-prod cassandra clusters on-prem. I was wondering to be able to run some open source tools which would give me insights about the tables in the clusters, basically how many are system and user keyspaces/tables and how many are unused i.e. no read/write activity in last 15 days or so etc. I'm thinking such tools would be available already since developeing them is easy. But I can't dig up tools like this from searching internet. If someone can direct me to any tools they use for similar purposes, that'd help We are using cassandra datastax 5.1.33 in our clusters

Tried google search Tried nodetool tablestats and writting my own script to compile data and extract info but looking for an existing tool to save time and effort

Answer 1

If you have a valid DataStax Enterprise (DSE) 5.1 subscription, you could setup & configure OpsCenter 6.8 that comes for free of license to use with DSE.

With OpsCenter 6.8, one can configure individual table level reads/writes to monitor for any traffic and then decide to drop them based on usage.

In addition to that, one could also leverage nodetool tablestats and look out for the Local read|write latency (or) Local read|write count metrics to understand if the table in question is being used since the time the DSE process was restarted.