Connect with the SQL Editor

Multi-tab SQL Editor

The Multi-tab SQL Editor allows you to open and work with multiple SQL files in parallel within a single browser session. You can load, edit, and run queries against different workspaces and databases, and save individual SQL files for future use.

Create and Open a New SQL File

Note: Ensure that the correct workspace and database are selected at the top of the file, and all queries are run against the intended database.

On the Cloud Portal, select Develop > Data Studio.
Navigate to the + New button on the right, and select New SQL file.

A new tab opens with an untitled SQL editor (for example, Untitled-1.sql). Each additional untitled tab is automatically numbered incrementally (such as Untitled-2.sql, Untitled-3.sql, etc.).

Save a SQL File

To save an untitled SQL file, select the Save As button on the top right. In the dialog, enter the filename and confirm its storage location.

Note: SQL files can only be saved in the Personal folder.

For further modifications, select Save, or you can rely on autosave. The editor autosaves content every 5 seconds, as indicated by the Save button changing to Saved.

If you try to close a file with unsaved changes, you will be prompted to save, discard, or cancel. Unsaved or untitled files are lost permanently when closed.

Set a Row Limit for Results

To limit the number of rows in the query result:

Select the three dots icon in the top right corner of the editor.From the list, select Settings.
The Settings panel shows a Limit results to option.
Select a row limit: 300,1000, or 3000. The default is 300 rows.

Alternatively, you can set the row limit by running the following command in the SQL Editor:

SQL

SET SESSION SQL_SELECT_LIMIT = 5000;

This example sets the value to 5000.

Troubleshooting

If you experience connection errors when running queries, verify that your IP address is allowed in the workspace group's firewall settings.
For additional assistance, contact SingleStore Support.