Skip to main content

SQL Editor

The SQL Editor is the in-console tool for running SQL queries against your warehouse. It supports query execution, automatic session saving, query profiles, and historical query records. You can also manage your running sessions directly from this interface.

To open the SQL Editor:

  1. Go to the VeloDB Cloud console.
  2. In the left navigation pane, click SQL Editor.

Run a query​

  1. Type or paste your SQL into the editor.
  2. Click Run (LIMIT 1000) to execute. Results appear below the editor with the query status.
  3. To download results directly, click the dropdown arrow next to Run (LIMIT 1000) and select Run and Download.

Work with results​

  • Click the search icon in the top-right corner of the results panel to filter rows.
  • Click the download icon next to the search icon to download the displayed results as a CSV file.
  • Click any column header to sort the results.
  • Click any cell to open the cell inspector and view its full value.

Query history​

Click the history icon in the results panel to open the query history. The history lists all SQL statements you have executed. To view a query profile, click the Query ID.

Note:

There is no Query ID for non-query statements or for failed statements.

Saves​

The Saves tab keeps an automatic archive of your SQL Editor tabs from current and previous sessions. Click any entry to load it back into the editor.

Query profile​

Query profiles are enabled by default for queries run from the SQL Editor and do not affect the performance of an individual query.

  1. Open Query history.
  2. Click the Query ID of the statement you want to inspect.

The profile page shows the execution plan as a Graph or Text view. Toggle between the Graph and Text tabs to switch views. Click Download to export the profile.

To learn more about how to optimize queries, see Query Profile Analyses

Sample queries​

The SQL Editor includes pre-built sample queries for common test datasets and tutorials, so you can explore features or run performance checks without writing SQL from scratch.

To open a sample query:

  1. Click the Templates tab in the SQL Editor.
  2. Choose Tutorials or Benchmark and click the query you want to open.
  3. The query loads into the editor. Click Run (LIMIT 1000) to execute it.

To view and manage running SQL queries, see Session Management.