Connecting to databases with DataStax Developer Studio

Use DataStax Developer Studio to connect with Apollo databases created using the DataStax Constellation console.

You can use DataStax Developer Studio to interact with Apollo databases created using the DataStax Constellation console.

When creating an Apollo 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 the DataStax Constellation console.

Limitations

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

  • Each Apollo 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 Apollo database operates using a single keyspace, you cannot create additional keyspaces using Developer Studio.

Procedure

  1. Open a browser, navigate to the DataStax Constellation console, and log in.
  2. 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.
  3. When prompted, enter the username and password used when creating your database through the DataStax Constellation console.
  4. Click Save to save the credentials.

Results

You can now interact with your Apollo 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 Apollo 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.