The Cassandra explorer provides a simplified interface to explore data, view rows and columns residing in a Cassandra cluster. You can explore internal or external Cassandra keyspaces. Cassandra explorer also provides a comprehensive search mechanism.
Follow the instructions below to connect to and explore a Cassandra cluster.
- Log in to the management console, and click Tools.
- Click Connect to Cluster in the Cassandra Explorer menu as shown below.
- Enter the connection details and click Connect. You have to provide connection details each time because the Cassandra explorer is designed to connect to several different internal or external clusters.
- Connection Url: connection url of the Cassandra cluster with ip and port. For example, localhost:9160 if you didn't set a port offset, and 10.8.99.101:9161 if you have set a port offset of one. This field is mandatory.
- Username: username of the Cassandra cluster.
- Password: password of the Cassandra cluster.
- Maximum Result Count: maximum results retrieved from the Cassandra cluster. The default value is 1000.
- The connected cluster opens, listing all available keyspaces and their column families.
Click on a selected column family to view its rows. You can search for rows with a given name and navigate easily through full-numbered pagination. For example,
Unlike relational databases where each table has a defined set of columns, Cassandra defines column families that only define the metadata of the columns. The actual columns that make up a row are determined by the client application. The actual columns of each row can vary from each other depending on the data stored in a row. Therefore, the above view does not carry the exact column names in table column headers. Instead we have named columns as "Column1", "Column2" etc, while actual column headers are shown inline with the column values themselves. Data is typically added to these columns through an API or a data service.
Click the View more link associated with each row in the column family to navigate to a comprehensive column explorer with facility to search column data across the row.