メインコンテンツまでスキップ
バージョン: 4.x

SQL Editor

The SQL Editor is the in-console tool for running SQL against your warehouse. It supports query execution, automatic session saving, query profiles, and historical query records, and it is also where you manage running sessions.

Open SQL Editor from the Work with data group in the left navigation.

Run a query​

Type or paste SQL in the editor and click Run (LIMIT 1000) to execute. The results appear below the editor together with the success or error status.

Click the dropdown on the right of Run (LIMIT 1000) and switch to Run and Download to download the query results directly.

sql console

In the results panel you can search results through the search box, or click a column header to sort.

sql console result

Sessions and query history​

Session records list the tabs you have opened in the SQL Editor. Click a SQL statement in the record to copy it back into the editor for another run.

query session

Query history lists the SQL statements you have executed. Click a statement to view its profile.

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

query history

Query profile​

Query plans are enabled by default for queries run from the SQL Editor and do not affect the performance of a single query. Click a query statement to open its execution plan page.

profile

  • Download — export the profile as TEXT or as a visual profile image.
  • Import Profile — load a profile in TEXT format to inspect it visually. This is useful for analyzing queries initiated from other clients.

Sample queries​

The SQL Editor ships with sample queries for common test datasets so you can do quick performance checks without writing anything yourself.

sql templates

To view and manage running SQL queries, see Connection → Sessions.