Connect to Cassandra
You can connect to Cassandra and make it available as a resource in Retool. Once complete, your users can write queries that interact with Cassandra data.
Requirements
All users for Retool organizations on Free or Team plans have global Edit permissions and can add, edit, and remove resources. If your organization manages user permissions for resources, you must be a member of a group with Edit all permissions.
To create a Cassandra resource, you need your:
- database host.
- keyspace for the database.
- local datacenter name.
- database username.
Allow Retool to access Cassandra
If Cassandra is behind a firewall, you must allow access from Retool's IP addresses. Add the IP addresses to your firewall's Allowlist before you create the resource.
1. Create a new resource
Sign in to your Retool organization and navigate to the Resources tab. Click Create new, then select Resource.
2. Select the resource type
Retool can connect to almost any API or database, and has built-in integrations for popular data sources. Select the Cassandra resource type.
3. Configure the resource
Specify a name and location for the Cassandra resource. Retool displays the resource name and type in query editors to help users identify them. Next, configure the required settings.
Credential
| Setting | Description |
|---|---|
| Host | The URL or IP address. |
| Keyspace | The keyspace name. |
| Local datacenter | The local datacenter name. |
| Database username | Your database username. |
Click Test Connection to verify that Retool can connect to Cassandra. If the test fails, check the resource settings and try again. Testing a connection only checks whether Retool can successfully connect to the resource. It cannot check whether the provided credentials have sufficient privileges or can perform every supported action.
4. Save the resource
Click Create resource to complete the setup. You can then click either Create app to immediately start building a Retool app or Back to resources to return to the list of resources.
Wrap up
Your Cassandra resource is now ready to use. To interact with Cassandra data, select the resource in the query editor. You can read data using SQL queries, write data using GUI queries (if enabled), and use the schema browser to search tables or columns.