Compose Database-as-a-Service Help and Documentation

Everything you need to know about Compose, Hosted or Enterprise, is here in our help system. Whether you run one database for your businesses' sole application or six different databases to support an entire corporation, we've got the information you need.

Data Browser for Scylla

A quick way to view your Scylla data

Overview

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

Keyspaces

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.

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 Sidebar

Tables

The Tables view has three tabs, Queries, Indexes, and Settings.

Queries

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 WHERE and ORDER BY below.

Running a `SELECT` command from the browser.

Running a SELECT command from the browser.

Click on the Run button, and the query results will be displayed under the command-box.

Indexes

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

Settings

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.

Users

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.

Users list.

Users list.

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.

Admin

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.

Creating a New Keyspace

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.

Running a `CREATE KEYSPACE` command.

Running a 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.

Creating a New Table

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.

Running a `CREATE TABLE` command.

Running a CREATE TABLE command.

Fill in a table name and define the columns. You may add properties by the toggled buttons WITH and AND below. Clicking on Run will create the table and it will appear in the list.


Still Need Help?

If this article didn't solve things, summon a human and get some help.

Data Browser for Scylla

A quick way to view your Scylla data