Sign inTry Free

Fusion SQL

On this page

Note

This is a Preview feature.

SingleStore Fusion SQL commands enable you to interface with the Management API from SingleStore Notebooks. Fusion SQL commands are run in the SQL and Python cells of a notebook. These commands are handled by the handler classes and are not sent to the database server.

You can also run Fusion commands outside of SingleStore Notebooks using the Management objects in the SingleStore Python SDK. Authenticate the connection using an API key. Refer to Generate an API Key for information on generating API keys on the Cloud Portal.

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

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

To use the Fusion SQL commands outside of the Notebook environment using the SingleStore Python SDK, 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 for more information.

Supported Fusion SQL Commands

Run SHOW FUSION COMMANDS to list all the available Fusion commands. Use the LIKE clause to return a list of commands that match the specified pattern, such as:

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.

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

In this section

Last modified: February 13, 2025

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK