The Scylla data browser provides access to manage keyspaces and users for your deployment. From the browser you can:
- view keyspaces and tables
- create keyspaces and tables
- create users
The top-level view of the browser is Keyspaces. Its table contains keyspace name, the keyspace replication information, and the boolean value for whether durable writes is set.
Keyspaces list in the browser.
There are three keyspaces that are created upon initial deployment; system, system_auth, and system_traces. They contain administrative tables for your deployment.
To view tables and data in a keyspace, click on its name.
The next view is the Tables pane, with a list of all the tables in the keyspace. Clicking on one of the table names opens a page with a sidebar and three tabs.
The Tables view has three tabs, Queries, Indexes, and Settings.
The first tab in Tables is Queries and is displayed when the Tables view is selected. It has a command-box to run a
SELECT query on the current table with toggled parameters
ORDER BY below.
SELECT command from the browser.
Click on the Run button, and the query results will be displayed under the command-box.
The second tab is Indexes. It has a table of the current indexes on the table and a Drop button should you wish to do drop a particular index from the table.
The Indexes tab.
The command-box has
CREATE INDEX formatted with the current table so you can make new indexes on other columns. You may name the index with the toggled parameter
scylla_index[name] below. Clicking on the Run button will create the index and it will appear in the table.
The third tab is Settings where you can drop the table. This is permanent. Please make sure you have proper backups before any deletions. To delete the current table, click on the Drop Table button. This cannot be undone.
The Users pane shows a table of current users and their permissions. There is a Revoke Permissions button on the right to remove users from the current keyspace.
You can add new users by clicking on the Create User button in the upper-right. It will bring up a command-box with
CREATE USER so you can set the username and password.
The Admin pane allows you to delete a keyspace. This is permanent, so please make sure you have appropriate backups before deletion. To delete the current keyspace, click on the Delete keyspace button.
Deleting a Keyspace
This cannot be undone.
In addition to managing existing keyspaces, it is possible to add new ones from the data browser.In the Keyspaces pane, in the upper-right there is a Create Keyspace button. Clicking on it brings up a command-box with
CREATE KEYSPACE WITH REPLICATION.
CREATE KEYSPACE command.
Name your new keyspace and then define its replication scheme. The toggled parameter
DURABLE_WRITES=false is below; otherwise durable writes are enabled by default.
Clicking on the Run button creates the new keyspace.
On the Tables pane there is a Create Table button in the upper-right. Click on it to bring up a command-box with
CREATE TABLE command.
Fill in a table name and define the columns. You may add properties by the toggled buttons
AND below. Clicking on Run will create the table and it will appear in the list.
If this article didn't solve things, summon a human and get some help.