# Fusion SQL

> **📝 Note**: This is a Preview feature.

SingleStore Fusion SQL commands enable you to interface with the [Management API](https://docs.singlestore.com/cloud/reference/management-api.md) from [SingleStore Notebooks](https://docs.singlestore.com/cloud/container-services/notebooks.md).

Fusion SQL commands allow you to perform the following operations:

* Create or delete workspace groups, request information on available workspace groups, list the workspace groups
* Create, suspend, resume, or delete workspaces, request information on workspaces, list the workspaces
* Create, update, or delete a folder in a Stage, request information on a folder
* Upload, download, modify, or delete a file in a Stage, personal space, or shared space, show information on files
* Run jobs using notebooks, show job parameters, runtimes, and executions, show jobs, delete jobs, wait on jobs
* List the regions available for a user
* Show Fusion SQL commands, help, and grammar

## Enable Fusion SQL

Fusion SQL commands are enabled by default in notebooks on the [Cloud Portal](https://portal.singlestore.com).

To use the Fusion SQL commands outside of the notebook environment using the [SingleStore Python SDK](https://singlestoredb-python.labs.singlestore.com/api.html#management-api), enable the `SINGLESTOREDB_FUSION_ENABLED` environment variable.

```
SINGLESTOREDB_FUSION_ENABLED=1
```

## Authentication

When used in notebooks, authentication is handled via signed JWTs. Refer to [Authenticate via JWT](https://docs.singlestore.com/cloud/security/database-access/authenticate-via-jwt.md) for more information.

## Run Fusion SQL Commands

Fusion SQL commands are run in the SQL and Python cells of a [SingleStore Notebook](https://docs.singlestore.com/cloud/container-services/notebooks/using-notebooks.md) on the [Cloud Portal](https://portal.singlestore.com). These commands are handled by the handler classes and are not sent to the database server.

You can also run Fusion SQL commands outside of SingleStore notebooks using the Management objects in the [SingleStore Python SDK](https://singlestoredb-python.labs.singlestore.com/api.html#management-api). Authenticate the connection using an API key. Refer to [Generate an API Key](https://docs.singlestore.com/cloud/reference/management-api/#section-idm4495199953840032756423936306.md) for information on generating API keys on the [Cloud Portal](https://portal.singlestore.com).

Explore the following notebooks for getting started:

* [Getting Started with Fusion SQL](https://www.singlestore.com/spaces/getting-started-with-fusion-sql/): Demonstrates how to create, suspend, and resume SingleStore Helios deployments using Fusion SQL commands.
* [Managing Stage files with Fusion SQL](https://www.singlestore.com/spaces/managing-stage-files-with-fusion-sql/): Shows how to create and delete files and folders in a Stage using Fusion SQL commands.

## Supported Fusion SQL Commands

Run [SHOW FUSION COMMANDS](https://docs.singlestore.com/cloud/reference/fusion-sql/show-fusion-commands.md) to list all the available Fusion commands. Use the `LIKE` clause to return a list of commands that match the specified pattern, such as:

```sql
SHOW FUSION COMMANDS LIKE '%WORKSPACE%';
```

You can also view the grammar and help for a Fusion SQL command using the `SHOW FUSION GRAMMAR FOR` and `SHOW FUSION HELP FOR` commands, respectively.

```sql
SHOW FUSION GRAMMAR FOR <command>;
SHOW FUSION HELP FOR <command>;
```

## In this section

* [CREATE STAGE FOLDER](https://docs.singlestore.com/cloud/reference/fusion-sql/create-stage-folder.md)
* [CREATE WORKSPACE GROUP](https://docs.singlestore.com/cloud/reference/fusion-sql/create-workspace-group.md)
* [CREATE WORKSPACE](https://docs.singlestore.com/cloud/reference/fusion-sql/create-workspace.md)
* [DOWNLOAD PERSONAL FILE](https://docs.singlestore.com/cloud/reference/fusion-sql/download-personal-file.md)
* [DOWNLOAD SHARED FILE](https://docs.singlestore.com/cloud/reference/fusion-sql/download-shared-file.md)
* [DOWNLOAD STAGE FILE](https://docs.singlestore.com/cloud/reference/fusion-sql/download-stage-file.md)
* [DROP JOBS](https://docs.singlestore.com/cloud/reference/fusion-sql/drop-jobs.md)
* [DROP PERSONAL FILE](https://docs.singlestore.com/cloud/reference/fusion-sql/drop-personal-file.md)
* [DROP SHARED FILE](https://docs.singlestore.com/cloud/reference/fusion-sql/drop-shared-file.md)
* [DROP STAGE {FILE | FOLDER}](https://docs.singlestore.com/cloud/reference/fusion-sql/drop-stage-file-folder.md)
* [DROP WORKSPACE GROUP](https://docs.singlestore.com/cloud/reference/fusion-sql/drop-workspace-group.md)
* [DROP WORKSPACE](https://docs.singlestore.com/cloud/reference/fusion-sql/drop-workspace.md)
* [RESUME WORKSPACE](https://docs.singlestore.com/cloud/reference/fusion-sql/resume-workspace.md)
* [RUN JOB USING NOTEBOOK](https://docs.singlestore.com/cloud/reference/fusion-sql/run-job-using-notebook.md)
* [SHOW FUSION COMMANDS](https://docs.singlestore.com/cloud/reference/fusion-sql/show-fusion-commands.md)
* [SHOW FUSION GRAMMAR FOR](https://docs.singlestore.com/cloud/reference/fusion-sql/show-fusion-grammar-for.md)
* [SHOW FUSION HELP FOR](https://docs.singlestore.com/cloud/reference/fusion-sql/show-fusion-help-for.md)
* [SHOW JOB EXECUTIONS FOR](https://docs.singlestore.com/cloud/reference/fusion-sql/show-job-executions-for.md)
* [SHOW JOB PARAMETERS FOR](https://docs.singlestore.com/cloud/reference/fusion-sql/show-job-parameters-for.md)
* [SHOW JOB RUNTIMES](https://docs.singlestore.com/cloud/reference/fusion-sql/show-job-runtimes.md)
* [SHOW JOBS](https://docs.singlestore.com/cloud/reference/fusion-sql/show-jobs.md)
* [SHOW REGIONS](https://docs.singlestore.com/cloud/reference/fusion-sql/show-regions.md)
* [SHOW PERSONAL FILES](https://docs.singlestore.com/cloud/reference/fusion-sql/show-personal-files.md)
* [SHOW SHARED FILES](https://docs.singlestore.com/cloud/reference/fusion-sql/show-shared-files.md)
* [SHOW STAGE FILES](https://docs.singlestore.com/cloud/reference/fusion-sql/show-stage-files.md)
* [SHOW WORKSPACE GROUPS](https://docs.singlestore.com/cloud/reference/fusion-sql/show-workspace-groups.md)
* [SHOW WORKSPACES](https://docs.singlestore.com/cloud/reference/fusion-sql/show-workspaces.md)
* [SUSPEND WORKSPACE](https://docs.singlestore.com/cloud/reference/fusion-sql/suspend-workspace.md)
* [UPLOAD FILE TO STAGE](https://docs.singlestore.com/cloud/reference/fusion-sql/upload-file-to-stage.md)
* [UPLOAD PERSONAL FILE TO](https://docs.singlestore.com/cloud/reference/fusion-sql/upload-personal-file-to.md)
* [UPLOAD SHARED FILE TO](https://docs.singlestore.com/cloud/reference/fusion-sql/upload-shared-file-to.md)
* [USE WORKSPACE](https://docs.singlestore.com/cloud/reference/fusion-sql/use-workspace.md)
* [WAIT ON JOBS](https://docs.singlestore.com/cloud/reference/fusion-sql/wait-on-jobs.md)

***

Modified at: November 21, 2025

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

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