Using CQL in DataStax Studio

Interacting 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 interactive 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 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
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 dev blog post Studio Multi-Model CQL Support.