Please leave your feedback with the Docs team.
Toggle Menu

Filter Results:

  • Astra DB
  • Astra Streaming
  • Luna Support
↓↑to navigate
↵to select
escto close
    powered by Apache Cassandra™
    Go to DataStax Home
    Dark Mode

    Instead of using the native CQL shell that is included in DataStax Enterprise (DSE)the standalone CQLSH client is a separate, lightweight tool you can use to interact with your database.

    Each DataStax Astra DB database includes an embedded CQL shell instance. In the Astra DB console, navigate to your database and click the CQL Console tab to open a CQLSH instance that is connected to your database.

    Alternatively, have a teammate provide access to their Astra database.

    • Change to the directory where you downloaded the CQLSH tarball and then extract it:
    • 1
    • date - The date that the tarball was released, such as 20210304.
    • From the directory where you extracted the CQLSH tarball, run the cqlsh script from the command line:
    • 1
    Use the  -b  option to specify the location of the secure connect bundle that you downloaded for your database. Pass the Client Id and Client Secret for your database role using the  -u  and  -p  options. For more, see Manage application tokens.
    • username - Client ID for the database role.
    • password - Client secret for the specified Client ID.
    • database_name - Name of the Astra DB database to which you want to connect. Include the absolute path to the secure connect bundle for the database, such as /Users/myuser/Downloads/secure-connect-database123.zip.
    *Configure the  cqlshrc  file*If you do not want to pass the secure connect bundle on the command line every time, set up the location in your  cqlshrc  file.
    In the `[authentication]  section of the  cqlshrc  file in  ~/.cassandra`, include the Client ID and Client Secret from your application token.Configure the `[connection]  section of the  cqlshrc  file in  ~/.cassandra` to include the path to your connection credentials.
    • 1
    You are connected directly to your database using CQLSH.
    • 1
    Switch to your  KEYSPACE , where you can issue CQL commands to create tables, insert data, and manage database resources:
    • 1
    • Jump to section: