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 the USE 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.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2025 DataStax, an IBM Company | Privacy policy | Terms of use | Manage Privacy Choices

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com