Using CQL in DataStax Studio

Interact with data in a DSE cluster by writing and executing CQL code in a notebook.

The notebook tutorial Working with CQL is installed with Studio. The tutorial provides hands-on steps to create and interact with data in a DSE cluster by writing and executing CQL code in a notebook. This interactive notebook provides steps to use CQL in DataStax Studio to:
  • 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 results as grid () to download results in CSV format.
  • View results as JSON () to download JSON.
You can use the keyspace menu to select the keyspace 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 drop down menu applies only to the current cell.
  • The selected keyspace is copied to new cells created below an existing CQL cell.
  • If a default keyspace is not selected, and there are no USE statements in the cell, all statements must be fully qualified to include the desired keyspace.

See the DataStax blog post Studio Multi-Model CQL Support.