Use the CQL console to interact with the databases in your datacenter
Mission Control allows you to use the CQL console in the UI to interact with the databases in your datacenter using the Cassandra Query Language (CQL). The CQL console is a web-based interface that provides a way to execute CQL commands and view the results.
You can use the CQL console to execute any supported CQL commands against your database, for example to create keyspaces or insert data. For a list of available commands, see the CQL shell commands reference in the Hyper-Converged Database (HCD), DataStax Enterprise (DSE), or Apache Cassandra® documentation.
Connect to the CQL console
-
In the Mission Control UI navigation menu, select your project, and then select your database cluster.
-
Click CQL Console.
-
Select your datacenter from the list of available datacenters.
-
Enter your username and password.
Download the CQL command line shell
You can download the CQL command line shell (cqlsh) utility on your local machine to interact with your database cluster using CQL commands outside of the Mission Control UI.
To download the cqlsh utility from the Mission Control UI, do the following:
-
In the Mission Control UI navigation menu, select your project, and then select your database cluster.
-
Click CQL Console.
-
Click Download Command Line Shell. The DataStax downloads page opens in a new browser tab.
-
Select your database Version from the list of available versions, and then select the option to agree to the terms of the license agreement.
-
Click Download. The
cqlshpackage downloads to your local machine. -
Start the
cqlshtool. For more information, see Starting thecqlshtool in the HCD, DSE, or Cassandra documentation.
