NoSQL: Important System Tables of the Cassandra

In this post, I am sharing an important list of Cassandra System Tables.

Cassandra DBA can use these tables for a different investigation like, Schema information, Roles information, Tracing information and others.

There are different keyspaces are available like, system, system_auth, system_schema, system_traces.

system_auth Keyspace:

1 2	SELECT *FROM system_auth.roles; SELECT *FROM system_auth.role_permissions;

system_schema Keyspace:

1 2 3 4 5 6 7 8 9 10

SELECT *FROM system_schema.views; SELECT *FROM system_schema.types; SELECT *FROM system_schema.triggers; SELECT *FROM system_schema.tables; SELECT *FROM system_schema.keyspaces; SELECT *FROM system_schema.indexes; SELECT *FROM system_schema.functions; SELECT *FROM system_schema.columns; SELECT *FROM system_schema.dropped_columns; SELECT *FROM system_schema.aggregates;

system_traces Keyspace:

1 2	SELECT *FROM system_traces.sessions; SELECT *FROM system_traces.events;

system Keyspace:

1 2 3 4 5

SELECT *FROM system.available_ranges; SELECT *FROM system.peers; SELECT *FROM system.peer_events; SELECT *FROM system.batchlog; SELECT *FROM system.batches;