Defining run behavior in DataStax Studio

With results visualization and profiling capability, Studio serves as debugging tool by executing code in a way that reproduces the settings used in their applications. When using Studio to interact with DSE, you are able to execute code written in CQL or Gremlin. Each language has its own set of configuration options that determine execution behavior.

Execution configurations provide different execution setups by passing a set of options that customize the run execution. Execution configurations are persistent so you can reuse them.

Standard run configurations are provided:

Provided standard run configurations
Cell type	Execution configuration	Settings
CQL	CL.ONE	Consistency level: `ONE` Timeout (MS): 10000 Max Results: 5000 CQL Tracing: Disabled
CQL	CL.Quorum	Consistency level: `QUORUM` Timeout (MS): 10000 Max Results: 5000 CQL Tracing: Disabled
CQL	CL.ALL	Consistency level: `ALL` Timeout (MS): 10000 Max Results: 5000 CQL Tracing: Disabled
CQL	CL.ONE.TRACE	Consistency level: `ONE` Timeout (MS): 10000 Max Results: 5000 CQL Tracing: Enabled
Gremlin	Transactional	Execute statement using real-time OLTP (online transaction processing) engine, traversal source `g`
Gremlin	Spark	Execute statement using OLAP (online analytical processing) engine, traversal source `a`

You can create a custom CQL execution configuration by adjusting these settings for your environment:

Consistency level: ANY, ONE, TWO, THREE, QUORUM, ALL, LOCAL_QUORUM, EACH QUORUM, SERIAL, LOCAL_SERIAL, LOCAL_ONE
Timeout (MS): milliseconds
Max Results: limit_results

CQL Tracing: Enabled or Disabled

In the top right of a code cell, hover over the play button ▶ and then click ▾ to list the existing configurations.

In CQL cells, the default execution configuration is CL.ONE so the play button is CL.ONE ▶.
In Gremlin cells, the default execution configuration is Executive using real-time (transactional) engine so the play button is Real-time ▶.

Select Manage Configurations.
Select an existing configuration to view settings.
For CQL cells only: Click + Add New Configuration to create an execution configuration.
1. Enter a self-describing Name.
2. Select a Consistency Level.
3. Enter a Timeout value in milliseconds.
4. Enter Max Results.
5. Optionally select the CQL Tracing check box.
Click Save.

New execution configurations are available to be selected from any CQL notebook cell.

Defining run behavior in DataStax Studio

Was this helpful?

Give Feedback