Connect with the SQL Editor

Create and Open a New SQL File

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

1. On the Cloud Portal, select Editor > Open SQL Editor.

2. 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:

1. Select the three dots icon in the top right corner of the editor.From the list, select Settings.

2. The Settings panel shows a Limit results to option.

3. 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:

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 cluster group's firewall settings.

• For additional assistance, contact SingleStore Support.