Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

Fusion SQL

Note

This is a Preview feature.

SingleStore Fusion SQL commands enable you to interface with the Management API from SingleStore Notebooks.

Fusion SQL commands allow you to perform the following operations:

  • Create or delete cluster groups, request information on available cluster groups, list the cluster groups

  • Create, suspend, resume, or delete clusters, request information on clusters, list the clusters

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

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.

Run Fusion SQL Commands

Fusion SQL commands are run in the SQL and Python cells of a SingleStore Notebook on the Cloud Portal. 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. Authenticate the connection using an API key. Refer to Generate an API Key for information on generating API keys on the Cloud Portal.

Explore the following notebooks for getting started:

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:

Was this article helpful?