Working with the query editor

The query editor opens in the data panel when you select a database, a table, or a view in the Connections section.

Running a queryRunning a query

To run a query to a database, establish or activate a connection with the database.

To build a query:

1. Under Connections, select a database, table, or image.

2. In the data panel, you will see a form with the default query:

   SELECT * FROM <table_name> LIMIT 10;
   

3. Use this query or edit it. The interface will suggest relevant parts of the query and highlight errors.

4. Click Run.

In the results panel, you will see a table with the query results.

When editing or running a query, you can use the following keyboard shortcuts (click to see the full list):

Click Open Command Palette to view a complete list of available commands and their corresponding keyboard shortcuts.

You can view your executed queries in query history and save them as templates.

PaginationPagination

You can use pagination in the query editor to manage result outputs. With pagination, you can:

• Switch between pages:

  • : First page
  • : Previous page
  • : Next page
  • : Last page

• Select the number of rows displayed per page. To do this, click the field with the number of rows (between the arrows) and select the appropriate limit.

• Get the total number of rows by clicking Total rows.

Each action you take with pagination re-runs the query and is logged in the query history.

Multi-queriesMulti-queries

In the query editor, you can use multi-queries, enabling you to run multiple queries as a single batch. These queries are executed within a single database session.

Multi-query example:

SELECT * FROM <table_1_name> LIMIT 10;
INSERT INTO <table_2_name>;

To run individual subqueries within a multi-query, highlight one or more subqueries and click Run current query. The editor will display the progress status of the highlighted queries.

Exporting query execution resultsExporting query execution results

To save the results in a format you like:

1. Click Export in the top-right corner of the panel with the results table.
2. Select the format: JSON,CSV or TSV.

A file with the results will be added to your browser's downloads section.

Setting up the query editorSetting up the query editor

Yandex WebSQL enables you to quickly edit your queries, including with features, such as context help or SQL syntax and error highlighting. To manage these features:

1. Click Settings in the bottom-left corner.
2. Go to the Query editor section.
3. Customize the editor theme (Visual Studio or High Contrast), font size and type, and the following editing feature options:
   • Editor tips
   • Syntax highlighting
   • Error highlighting
   • Editor minimap
   • Autoclosing of quotes
   • Autoclosing of parentheses

ClickHouse® is a registered trademark of ClickHouse, Inc.