DataStax OpsCenter Documentation

Browsing the database

Use the Data Explorer area to browse the keyspaces, column families, and data stored in the Cassandra database of a cluster and to zoom in on the columns of a particular row.

To browse the Cassandra database:

  1. Select Data Explorer in the OpsCenter console.

    A list of keyspaces in the cluster appears. By default, the list includes the OpsCenter keyspace, which contains column families of data in the cluster.

  2. Click one of the keyspaces. For example, click the OpsCenter keyspace.

    The list of column families appears.

  3. Click a column family. For example, click events_timeline and expand the OpsCenter console window, so you can see more values.

    A row keys, columns, and data values of the events_timeline column family appear in tabular format. You may notice that some data values are hex-encoded, not human-readable values, and other values are perfectly readable. Internally, Cassandra stores row key names, column names and column values as hex byte arrays. If possible, OpsCenter converts data to text you can read.

  4. Click the heading row of the table to see the sort control (the arrow on the right). Toggle the sort control to sort the rows in ascending or descending order.

  5. To browse through the data, use the scroll bar or click Next to page through the data.

To zoom in on a particular row:

  1. Assuming the events_timeline column family is still selected, type the key for a row in the Key text entry box. For example, type the row key timeline_start.

    If you set up a secondary index on the column family, the Key drop-down lists key choices.

  2. Click the search control (the hourglass icon).

    The columns and values of the row appear.