Cassandra Connection Help

Cassandra uses a query language called CQL that does not include all features of SQL. For information on the syntax supported by RazorSQL for querying and updating Cassandra databases, see the following:

RazorSQL Cassandra SQL Syntax Guide

To connect to Cassandra in RazorSQL, select the Connections - Add Connection Profile menu option. Then, select Cassandra as the database type and click "Continue". The default connection type for Cassandra is the Cassandra JDBC driver. To have RazorSQL download and install the Cassandra driver, click the "Auto Download Driver" button on the right-side of the screen. This will download a fully configured Cassandra driver to your machine.

Once the driver is finished downloading, the following information needs entered to be able to connect to Cassandra:

Profile Name: This is the name of the RazorSQL connection profile.

Login: This is not usually used for Cassandra, but if your database has this enabled, enter your login id.

Password: This is not usually enabled for Cassandra, but if your database has this enabled, enter your password.

Host or IP Address: The host or ip address of the Cassandra database server.

Port: The port the Cassandra database is listening on. If this is left blank, 9160 will be assumed.

Keyspace Name: If a value is specified for the keyspace name, after connecting, RazorSQL will set that value as the default keyspace.