Index wizard wizards

Wizards for generating wizards generate valid CQL statements that create, edit, or clone a new UDT in a cluster.

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

The New Index and the associated Edit Index and Clone Index wizards generate valid CQL statements that create, edit, or clone a new UDT in the specified cluster.

New User-defined Type wizard 

The New Index wizard provides a visual way to generate valid CQL statements that create one or more secondary indices for the specified table.

To display the New Index wizard:
  1. Select the File > New > Index menu item
  2. Right-click in the schema navigator and select New Index
  3. Press the key shortcut ⌥⇧+⌘+I(Mac OS X) or Ctrl+Alt+Shift+I (Linux / Windows)
Navigate between panels using the Previous and Next buttons. A Last button also skips from the current panel to the Summary panel, if you won't be editing any fields on those panels.

The first panel (Create Index) of the Create Index wizard displays. There are two panes on this panel: one that displays index settings and allows editing of them, and a CQL Preview pane that displays the CQL statement(s) for creating the index generated from the values in the first pane.

The editable fields are:
Connection
choose an existing connection or create a new one
Keyspace
choose an existing keyspace or create a new one
Table
choose an existing table or create a new one
Secondary indices
add valid index names and columns

After selecting Next, the second panel (Summary) of the New Index wizard displays.

In the Summary panel you can review the final CQL that will be generated and choose between the following actions:
  • 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 and Clone Index wizards 

The New Index and Clone Index wizards have the same GUI panels as the New Index wizard, but they load the constituent data in the fields so you can edit or clone an index.