Can't select system keyspace from keyspaces dropdown menu

[yadkov]

While creating queries in builder mode from Grafana to Astradb I can't select the system keyspace from keyspaces dropdown menu.

When I switch to code mode I am able to select from the system keyspace.

Grafana version: 8.5.13
Astradb plugin version: 0.2.1

[ktw4071]

Hi @yadkov,
Could you kindly upload UI screenshot that I can refer to? I will reproduce and fix it.
Thanks

[yadkov]

This is the builder mode:

This is from the code mode:

[yadkov]

Any updates?

[ktw4071]

Hello @yadkov, been working with other work. If it's not an urgent issue, I will pick up after finishing my current work.

[scottlepp]

Hi @yadkov we intentionally filter out system keyspaces since these are system generated tables.

Can you please help understand the use case of why you want to query these? Thanks.

[yadkov]

We would like to monitor the partions counts and their corresponding size. In order to do this we need the data which is stored in size_estimates in the system keyspace.

[scottlepp]

@yadkov thanks for the update. This seems like a more admin/advanced use case where the user knows the schema/metadata and how to write the CQL to get it, and has access to system tables.

The query builder is really meant for users who are not familiar with CQL and shouldn't see system tables, but I suppose this can be managed with permissions in Cassandra.

With your scenario, the user would rather use the query builder ui rather than just writing the CQL?

[yadkov]

CQL is preferred.

[scottlepp]

Then it seems accessing system tables from the query builder ui is not necessary. Going to close this.

[yadkov]

Maybe a comment comment in the documentation about the system keyspace could be useful.