Creating a simple notebook in DataStax Studio

Steps to create a simple notebook in DataStax Studio.

Steps to create a notebook that contains text and runnable code. A notebook requires a name and a connection to a DSE cluster.

Procedure

  1. Open the Studio server by entering http:/URI_running_DSE:9091/ in your web browser.

    DataStax Studio opens to the Notebooks page.
  2. Click the plus (+) to add a notebook.
    The Create Notebook dialog displays.
  3. Enter the notebook name.
  4. Select an existing connection or click + Add New Connection.
  5. For a new connection, enter the connection information:
    Name
    Name of the connection from the notebook to a DSE cluster.
    Host/IP (comma delimited)
    The host names or IP addresses of the DSE cluster to connect to. All hosts must be in a single datacenter. Default: localhost.
    Username
    Optional. DSE username for logging in.
    Password
    Optional. DSE password for logging in.
    Port
    IP connection port. Default: 9042.

    For example, to connect to a single-node DSE cluster on the local host using the default port.

    Name
    My First Connection
    Host/IP
    127.0.0.1
    Port
    9091
  6. Click Test to verify the connection works.
  7. Optional: To configure a secure encrypted connection, select the Use SSL check box.
    The Truststore and Keystore fields display. See Using SSL connections in DataStax Studio.
  8. Click Save.
    A connection is created from the notebook to the DSE cluster.
  9. Select Create.
    The notebook displays with a single empty (default) cell in CQL edit mode. This can be changed to Gremlin, SparkSQL, or Markdown.

The following steps show a Markdown example:

  1. In the default cell, change the drop-down to Markdown.
  2. Add some verbiage to the default cell:
    My Notebook
    -----------
    Schema-aware content-assist improves productivity. Studio inspects your schema to make smart suggestions based on your data model. When you work with properties of a person, then you'll see suggestions for name and date_of_birth. 
  3. Select Run Cell to render the marked down text.


  4. Create another Markdown cell.