Connecting to databases with DataStax Developer Studio

Use DataStax Developer Studio to connect with DataStax Astra databases created using the DataStax Cloud console.

You can use DataStax Developer Studio to interact with Astra databases created using DataStax Astra for Apache Cassandra.

When creating an Astra database, an embedded Developer Studio instance is automatically configured for interactive CQL commands. Each notebook in Developer Studio has only one connection, but a connection can serve multiple notebooks.

Prerequisites

Create a database using DataStax Astra for Apache Cassandra.

Limitations

When using Developer Studio with an Astra database, understand the following limitations:

  • Each Astra database includes a Developer Studio instance that works only with that database.
  • Only the database owner can access the integrated Developer Studio. To share notebooks, you must export them for your teammates to upload.
  • Because each Astra database operates using a single keyspace, you cannot create additional keyspaces using Developer Studio.

Procedure

  1. Open a browser, navigate to DataStax Astra for Apache Cassandra, and log in.
  2. Click Manage via DataStax to open DataStax Astra on Google Cloud.
  3. From the Databases page, under Actions, click the ellipsis () for the database you want to connect to and select Developer Studio.
    A DataStax Developer Studio instance that is connected to your Cassandra database opens.
  4. When prompted, enter the username and password used when creating your database through the DataStax Cloud console.
  5. Click Save to save the credentials.

Results

You can now interact with your Astra database using Developer Studio. Use the example notebook to create tables and rows in your keyspace.

Explore your keyspaces

To view all available keyspaces, run the following command:
DESCRIBE KEYSPACES;
View the keyspace that you created for your Astra database:
DESCRIBE KEYSPACE my_keyspace;

What's next

Switch to your keyspace, which you can use to issue CQL commands to create tables, insert data, and manage database resources:
USE my_keyspace;

See Introduction to CQL to learn more about using CQL commands.