Use CQL in DataStax Studio
To help you get started, your DataStax Studio installation includes tutorial notebooks.
The Working with CQL notebook provides a hands-on tutorial to create and interact with data in a DSE cluster by writing and executing CQL code in a notebook.
Use this notebook to learn about the following:
-
Intelligent editor features for CQL cells.
-
Viewing the CQL schema with
DESCRIBE
commands. -
Use CQL templates and schema-aware content assist to help you form valid CQL statements.
Content assist can propose valid CQL keywords, table names, and column names, depending on which elements are appropriate to reference in a given context.
-
Use syntax validation and domain validation.
-
View and download results as tables (CSV), charts, or JSON.
SELECT and USE statements in Studio
To select a keyspace, use the Keyspace menu, or specify the CQL USE
statement.
The following rules apply to USE
statements in Studio:
-
The keyspace selected in the Keyspace menu applies only to the current cell.
-
The selected keyspace is copied to any new cells that you create below an existing CQL cell.
-
USE
statements apply only to the current cell. -
A
USE
statement overrides the default keyspace setting for all statements that follow theUSE
statement within that cell. -
If a default keyspace isn’t selected from the Keyspace menu, and there are no
USE
statements in the cell, then all statements must be fully qualified to include the desired keyspace.
See also
For more information, see Studio Multi-Model CQL Support.