Syntax

CREATE WORKSPACE [ IF NOT EXISTS ] '<workspace_name>'
    [ IN GROUP { ID '<group_ID>' | '<group_name>' } ]
    WITH SIZE '<workspace_size>'
    [ AUTO SUSPEND AFTER <suspend_time> { SECONDS | MINUTES | HOURS | DAYS } WITH TYPE { IDLE | SCHEDULED | DISABLED } ]
    [ ENABLE KAI ]
    [ WITH CACHE CONFIG <multiplier> ]
    [ WAIT ON ACTIVE ]

Arguments

• workspace_name: Name of the workspace.

• group_ID, group_name: ID or name of the deployment (workspace group) in which the workspace is created.

• workspace_size: Size of the workspace in the workspace size notation, for example, "S-1".

• suspend_time: Time in the specified units after which the workspace is automatically suspended, depending on the specified suspend type.

• multiplier: Specifies the multiplier for the persistent cache associated with the workspace.

Remarks

• Specify the IF NOT EXISTS clause to create a new workspace only when a workspace with the specified name does not exist already. If a workspace with the specified name already exists and the IF NOT EXISTS clause is not specified, the CREATE WORKSPACE command returns an error.

• If the WITH CACHE CONFIG clause is specified, it enables the cache configuration multiplier. It can have one of the following values: 1, 2, or 4.

• If the WAIT ON ACTIVE clause is specified, query execution is paused for this workspace until it reaches the ACTIVE state.

• Specify ENABLE KAI to enable SingleStore Kai (the MongoDB® API) for the workspace.

Example

The following command creates a new workspace named testws in a workspace group named s2wsg:

CREATE WORKSPACE 'testws' IN GROUP 's2wsg'
   WITH SIZE 'S-1' WAIT ON ACTIVE;