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.
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.
Clicking on 'New' will simply clear the editor from any SQL.
Write your SQL in the editor, and by clicking on 'Execute' you will allow the query to run.
The query will run and, if successful, the data returned by your query will be displayed in the table underneath.
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
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.
This allows you to access and load any of your saved SQL from the past.