Use CQL in DataStax Studio

Your DataStax Studio installation includes a tutorial notebook called Working with CQL. This tutorial provides hands-on steps to create and interact with data in a DSE cluster by writing and executing CQL code in a notebook.

Use this notebook to learn how to do the following:

Select CQL as the language to enable intelligent editor features.
View the CQL schema.
Use CQL templates and schema-aware content assist to help you form valid CQL statements:
- Propose valid CQL keywords.
- Propose valid table names anywhere a table can be referenced in a CQL statement.
- Propose column names anywhere a table can be referenced.
Identify errors with DSE domain-specific validations when CQL statements violate a constraint.
View results in table view or different styles of charts.
View and download results in CSV format ().
View and download results in JSON format ().

To select a keyspace, use the Keyspace menu, or specify the CQL USE statement. The following rules apply to USE statements in Studio:

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

For more information, see the DataStax blog post Studio Multi-Model CQL Support.

Use CQL in DataStax Studio

Was this helpful?

Give Feedback