Define run behavior with execution configurations
With results visualization and profiling capability, Studio is a powerful debugging tool that executes 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, Gremlin, or Spark SQL. Each cell 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 across notebooks and cells.
To execute only the highlighted statement, select the statement in the cell, and then click Run Cell. |
Run configuration options
Cell type | Execution configuration | Settings |
---|---|---|
CQL |
|
|
CQL |
|
|
CQL |
|
|
Gremlin |
Transactional |
Execute statement using real-time (transactional) engine for OLTP (online transaction processing), traversal source |
Gremlin |
Analytic |
Execute statement using analytic engine (Spark) for OLAP (online analytical processing), traversal source |
Spark SQL |
Run |
Execute statement with Spark SQL query engine with AlwaysOn SQL service. |
LOCAL.ONE and LOCAL.QUORUM
The default execution configuration is LOCAL.ONE
.
When connecting to Astra DB Serverless, the default consistency is LOCAL.QUORUM
.
Set and manage execution configurations
-
In the upper-right corner of a code cell, hover over Run Cell, and then Configurations to switch and manage your execution configurations.
The Run Cell label changes based on the default or selected execution configuration:
-
In CQL cells, the default execution configuration is CL.ONE.
-
In Gremlin cells, the default execution configuration is Real-time, which means execute using real-time (transactional) engine.
-
In Spark SQL cells, all statements are executed with Spark SQL query engine with AlwaysOn SQL service.
-
-
Select Manage Configurations to inspect and create configurations.
-
You can select an existing configuration to view its details.
-
For CQL cells only, you can add a new configuration by clicking Add New Configuration and providing the following settings:
-
Name: The configuration name
-
-
Consistency level:
ANY
,ONE
,TWO
,THREE
,QUORUM
,ALL
,LOCAL_QUORUM
,EACH_QUORUM
,SERIAL
,LOCAL_SERIAL
,LOCAL_ONE
-
Timeout (MS): An integer representing milliseconds
-
Max Results: An integer representing a number of records
-
CQL Tracing: Enable or disable CQL tracing
-