CQL Scripts

The CQL Scripts view provides a simple file manager for creating, editing, and deleting CQL scripts.

DataStax DevCenter is compatible with DataStax Enterprise (DSE) versions up to 5.0.

There are two types of files: scratchpads (new scripts having a default name) and already saved scripts. DevCenter saves CQL scripts (both scratchpads and named scripts) in your DevCenter workspace under these directories:
  • scratchpads: user-home /.devcenter/DevCenter/.default
  • CQL scripts: user-home /.devcenter/DevCenter/CQLScripts

Select one or more CQL scripts by typing ⌘+click (Mac OS X) / Ctrl+click (Windows / Linux).

Note: When you open a CQL script for editing using File > Open File, any changes you make are to your workspace copy of the CQL script and not to the original file.

New CQL script  

Create a new CQL script by selecting the File > New CQL Script, typing ⇧+⌘+N (Mac OS X) / Ctrl+Shift+N (Windows, Linux), or clicking the New CQL Script icon in the toolbar of this view.

Open CQL script  

Edit an existing script by clicking the Open CQL script action or typing ⌘+F3 (Mac OS X) / Ctrl+F3 (Windows, Linux).

Also import an existing script by selecting File > Open File.

Delete CQL script  

You delete a script by:
  • clicking the Delete CQL script icon
  • Mac OS X, Windows, Linux: typing DEL
Note: In case you must delete your DevCenter workspace directory, make sure you have copied or moved the existing CQL scripts to a different location on your disk.

Properties

You view a CQL script's properties by right-clicking on the script and selecting Properties in the contextual menu or typing ⌘+I (Macintosh) / Ctrl+I (Windows, Linux).

You see all the file information (for example, the time the file was last modified and its read, write, execute permissions).