Notebook cells in DataStax Studio

Notebook cells contain markdown text, CQL, Gremlin code, or Spark SQL. A notebook consists of a sequence of cells. A cell is a multi-line text input field.

Run a cell

There are three ways to execute a cell’s contents:

Press Shift+Enter with focus on the cell
Click Run Cell
In the menu, click Cell, and then select Run

The cell language determines the cell’s execution behavior and whether you can customize the run behavior:

Gremlin
CQL
Spark SQL
Markdown

Execution configurations define the run behavior.

You can manipulate the output format using results controls.

Execution configurations define the run behavior. Custom run configurations are supported.

You can manipulate the output format using results controls.

The execution configuration is not configurable.

Markdown is a superset of HTML.

Use Markdown to document the computational process in a literate way, alternating descriptive text with code. Supported styles include italics, bold, lists, and headings. Anchored links between sections are also supported.

Click Run Cell to preview the rendered Markdown.

By default, every cell is a code cell. To change a cell’s type, select a different cell language or use Keyboard shortcuts in DataStax Studio.

Notebook controls

View Schema: Switch to schema view to interact with contextual views of data.

The following controls are available in schema view:
- Reset Selections: Reset drop down selections.
- Dock to Top: Dock schema to the top.
- Dock to Side: Dock schema to the side.
View History: Display notebook history to view and manage notebook revisions.
Add Cell: Add a cell in the current location.

Cell controls

Run Cell: Display the markdown or run the code and display the results.

Select one or more statements in the cell to execute only those highlighted statements.
Hide Code Editor: Hide the code editor.
Editor Validations: Toggle to enable (on) or disable (off) editor validations.
Maximize Cell: Maximize the cell.
Other Cell Actions: Access additional cell controls, including the following:
- Delete
- Move Up
- Move Down
- Copy Cell Link
- Clear Results

CQL and Gremlin results controls

Use these controls to change the presentation of results from the last statement executed in a cell. These controls aren’t available for all cell languages.

JSON
Table
Pie Chart
Bar
Line
Area
Scatter
Graph
Settings