Query Editor
Want even more data? Write your own SQL in the Query Editor; your personal and advanced data Explorer.
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 queries.
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.
Successful query
Successful 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 FROM SAVED
This allows you to access and load any of your saved SQL from the past.
Load a saved SQL
Load a saved SQL