Creating and Using Workspaces

After logging into the SingleStoreDB Cloud Portal you can create a workspace by clicking the Create Workspace option. You can also create and manage workspaces through the Management API.

Workspace group names length should be 1-255 characters.

Workspace name length should be 1-32 characters and can consist of digits, lowercase letters, and hyphen (-).

Each workspace provides a connection endpoint which you can use to connect from a client, IDE, or application. You can also use the SQL Editor in the Cloud Portal to connect and run queries directly in your selected workspace.

Options Available When Creating a Workspace

Regions are datacenter geographies in which a SingleStoreDB Cloud workspace runs. While any region can be selected, select the region that corresponds to the same region in which your target application is running. Note that regions vary in price.

Workspace Size Consideration should be given to compute, memory, and storage needs when selecting workspace size. A workspace’s size can later be increased or decreased as required.

Workspace Restriction SingleStoreDB Cloud provides for Classless Inter-Domain Routing (CIDR) allowlisting (whitelisting) to restrict the networks that can access a workspace. This can be defined when initially creating the workspace, or modified via editing the IP Allowlist once the workspace has been created.

Creating and managing workspaces can be done through the Cloud Portal User Interface (UI) or by using the Management API / SQL. The following functions are available via these management interfaces.

  • ATTACH/DETACH DATABASE

  • CONFIGURE FIREWALL

  • CONFIGURE USERS

  • CONNECT

  • CREATE DATABASE

  • CREATE WORKSPACE

  • DELETE WORKSPACE GROUP

  • TERMINATE WORKSPACE

Executing DROP DATABASE in a workspace can be only done from the primary R/W database. If the database is detached it can be dropped from the UI or Management API. If this command is run on the primary R/W database it will drop the database from all the workspaces including the read-only copies.

For more information on using workspaces see:

Manage Organizations

Manage Workspaces

IP Address Allowlisting

Flexible Usage Model