Browse and edit Cassandra tables

Browse keyspaces and tables, read a partition, edit cells with conditional writes, and see TTL and WRITETIME.

The sidebar lists keyspaces and, inside each one, tables, materialized views, indexes, types, functions and aggregates. System keyspaces are marked. Expanding a table shows its columns with their role: partition key, clustering, static or regular. On ScyllaDB, the tree also shows whether a keyspace uses tablets or vnodes, and it lists CDC logs. Definitions of types and functions are read-only, and you change them from the console.

A table tab has a Data section and a DDL section. The DDL is built from system_schema and is read-only. In Data, you read one partition by its key, or take a sample. Pages come from a paging state that Tablyne keeps, and you move with Next. You can load TTL and WRITETIME for a row’s non-key cells, which makes one extra read.

To edit, change a cell in the grid. The change is staged until you review it. Each operation is an UPDATE with IF conditions on the original values, so a changed row is reported as a conflict. By default each changed cell keeps its current TTL. You can instead choose no expiration or a new TTL.

The grid refuses what CQL cannot do safely. It will not edit a primary key column in place, a static column per row, or a counter by value, and counters become explicit increments. It does not duplicate a row, because an INSERT with the same key only overwrites it. It cannot edit a cell that reads as NULL, and an empty collection also reads as NULL. Edit those cells in the console. Deleting needs the whole row image to be verifiable, so a row with a null column, a collection or a counter cannot be deleted from the grid. On Amazon Keyspaces, collections, UDTs, tuples and durations are read-only in the grid. Materialized views and CDC logs are read-only too.

The table menu also offers add column, drop column, create index and table options such as default TTL, gc_grace_seconds, comment and compaction. Each one shows its CQL for review first. CQL has no transactional DDL, so the review is valid only for the schema at that moment.

Copying a table to another connection is not available for Cassandra and ScyllaDB.