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
DESCRIBEcommands. -
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.
-
USEstatements apply only to the current cell. -
A
USEstatement overrides the default keyspace setting for all statements that follow theUSEstatement within that cell. -
If a default keyspace isn’t selected from the Keyspace menu, and there are no
USEstatements in the cell, then all statements must be fully qualified to include the desired keyspace.