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 Connect to Cluster.
- 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. e.g., localhost:9160 , 10.8.99.101:9161. 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 itsrows. 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. Instead we have named columns as "Column1", "Column2" etc.
Data is typically added to these columns through an API or a data service. For example, refer to Cassandra Keysapce and Column Family Operations sample.
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.
