Using DevCenter 

A short tutorial on using DataStax DevCenter to create and maintain DataStax Enterprise databases.

This tutorial introduces DevCenter. Using sample queries files, it shows you how to use CQL to extract data from the DataStax Enterprise database.

Prerequisites

  • Download and install DataStax DevCenter.
  • A DataStax Enterprise cluster installed and running.

This tutorial uses a simple CQL schema included with DevCenter and provides some data.

Procedure

  1. Select Open CQL Script in the CQL Scripts pane to open the sample VideoDb schema CQL file.
    devcenter-home-directory/examples/videodb-schema.cql
  2. Select the Execute CQL Script button.

    A new node, videodb, appears in the Schema Navigator pane.

  3. Open the sample VideoDB data file from the CQL Scripts pane to insert some data in the videodb schema.
    devcenter-home-directory/examples/videodb-inserts.cql
  4. Execute the CQL statements.
  5. Open the sample VideoDB queries file from the CQL Scripts pane.

    The file contains some sample queries to execute against the videodb schema. Copying and pasting them into a blank CQL script and then executing them illustrates how to extract data from the database.

    devcenter-home-directory/examples/videodb-sample-queries.cql
  6. Open the VideoDB user-defined type (UDT) and tuples file from the CQL Scripts pane.
    This file demonstrates usage of UDTs and tuples.
    devcenter-home-directory/examples/videodb-udts-tuples.cql