Query Editor

We can use the lightweight Query Editor UI for running SQL commands against a ClickHouse instance without installing additional software.

Query Editor Query Editor

Currently Query Editor supports basic syntax highlighting and query auto-completion feature is under development.

To open Query Editor:

  • Open the Workspace you have access
  • Connect to the ClickHouse instance
  • Click on the Query Editor button from the navigation area.

Note: As the Query Editor is running over http(s) connection, running queries which give high volume response is not supported.

The newly improvised query editor features autocomplete features auto-complete specific to ClickHouse SQL. The suggestions are provided as we type in the editor.

Query Editor - Auto-Complete in action Query Editor - Auto-Complete in action

We can also export the query results to the local computer in CSV format.

Query Editor - Export results Query Editor - Export results

What Next? -> ClickHouse Client