What is it?

The Query Editor, in comparison to the Explorer, is a more technical and flexible way for you to collect data by writing your own SQL.
Write any ClickHouse compatible SQL and execute it to get the data you're looking for. All SQL statements will be executed against your ClickHouse database.

How to use it

When you enter the Query Editor the text editor will always be a blank canvas for you to start writing your own SQL.
Let's run through the different options you have.

NEW

Clicking on 'New' will simply clear the editor from any SQL.

EXECUTE

Write your SQL in the editor, and by clicking on 'Execute' you will allow the query to run.
Sucessful query
Sucessful query
The query will run and, if successful, the data returned by your query will be displayed in the table underneath.
💡‍ Hints
Here are a couple of quick commands you can use when writing your SQL: Control + Space Will give you the table and fields that are available to you.
Command + Enter Shortcut to run the query
You'll be assisted with messages
Example of message for sucessful query execution
Example of message for sucessful query execution
Assisting messages might appear
Assisting messages might appear
Example of error message for unsuccessful query execution
Example of error message for unsuccessful query execution

SAVE

If you have any query that you'd like to re-visit regularly, you can save your SQL and revisit it at any point in time.
Note that any saved SQL will be stored and accessible from your account only.
Save any SQL you want to re-visit
Save any SQL you want to re-visit

LOAD

This allows you to access and load any of your saved SQL from the past.
Load a saved SQL
Load a saved SQL