# CREATE WORKSPACE

Creates a new workspace in the specified workspace group. Refer to [Compute Workspaces](https://docs.singlestore.com/cloud/getting-started-with-singlestore-helios/compute-workspaces.md) for more information.

## 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](https://docs.singlestore.com/cloud/reference/singlestore-kai.md) (the MongoDB® API) for the workspace.

## Example

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

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

***

Modified at: September 15, 2025

Source: [/cloud/reference/fusion-sql/create-workspace/](https://docs.singlestore.com/cloud/reference/fusion-sql/create-workspace/)

(An index of the documentation is available at /llms.txt)