Databases
Apache Cassandra
Execute queries to a Cassandra cluster with cqlsh.
Prerequisites
To get the most out of this guide, you will need to:
- Either create an account in our managed instance or deploy your own hoop.dev instance
- You must be your account administrator to perform the following commands
Features
The table below outlines the features available for this type of connection.
- Native - This refers to when a database client connects through a specific protocol, such as an IDE or client libraries through
hoop connect <connection-name>
. - One Off - This term refers to accessing this connection from hoop web panel.
Feature | Native | One Off | Description |
---|---|---|---|
TLS Termination Proxy | The local proxy terminates the connection with TLS, enabling the connection with the remote server to be TLS encrypted. | ||
Audit | The gateway stores and audits the queries being issued by the client | ||
Data Masking (Google DLP) | A policy can be enabled to mask sensitive fields dynamically when performing queries in the database. | ||
Data Masking (MS Presidio DLP) | A policy can be enabled to mask sensitive fields dynamically when performing queries in the database. | ||
Credentials Offload | The user authenticates via SSO instead of using the service credentials. | ||
Interactive Access | Interactive access is available when using an IDE or connecting via a terminal for analysis exploration. |
Configuration
Name | Required | Description |
---|---|---|
CQLSH_KEYSPACE | yes | The keyspace target |
CQLSH_HOST | yes | The host of the Cassandra cluster |
CQLSH_PORT | no | The Vault Token. Defaults to 9043 |
CQLSH_USER | no | The user can connect in the Cassandra cluster. |
CQLSH_PASSWD | no | The password to connect in the Cassandra cluster. |