Keyspace wizards
Wizards for generating valid CQL statements that create, edit, or clone a new keyspace in a cluster.
DataStax DevCenter is compatible with DataStax Enterprise (DSE) versions up to 5.0.
The New Keyspace and the associated Edit Keyspace and Clone Keyspace wizards generate valid CQL statements that create, edit, or clone a new keyspace in the specified cluster.
New Keyspace wizard
- select the menu item
- right-click in the schema navigator and select New Keyspace
- press the key shortcut ⌥⇧+⌘+K(Mac OS X) or Ctrl+Alt+Shift+K (Linux / Windows)
The first panel (Basic Settings) of the New Keyspace wizard displays. There are two panes on this panel: one that displays keyspace settings and allows editing of them, and a CQL Preview pane that displays the CQL statement for creating the keyspace generated from the values in the first pane.
- Connection
- choose an existing connection or create a new one
- Keyspace name
- type in a valid keyspace name (invalid names are noted in red)
- Replication strategy
- which data replication strategy class (SimpleStrategy single data
center or NetworkTopologyStrategy multiple datacenters) to use;
the strategy determines where replicas are placed
- Replication factor: which replication factor to use; the factor is the number of replicas across the cluster
- Durable writes
- by setting this property, data written to the keyspace bypasses the commit logs
After selecting Next, the second panel (Summary) of the New Keyspace wizard displays.
- Whether to execute the generated statement(s) using the current connection or not
- Whether to insert the generated statement(s) into
- a new CQL editor pane
- an existing CQL editor pane
Both panels have an uneditable CQL preview pane showing the CQL statement to be generated according to the current values of the wizard's editable fields.
Edit Keyspace wizard
The Edit Keyspace and Clone Keyspace wizards have the same GUI panels as the New Keyspace wizard, but they load the constituent data in the fields so you can edit or clone a keyspace.
Export Keyspace wizard
The Export Keyspace wizard consists of a single Summary panel that allows you to export the data-definition language that creates a keyspace. You access the Export Keyspace wizard by right-clicking on a keyspace in the Schema Navigator. The wizard contains a CQL preview panel for you to review the CQL being generated that recreates the keyspace.
- User-defined type
- Table
- Index
- Materialized view
- Functions
- Aggregates
You can select whether to import the CQL into an existing query editor or to create a new one.