SQL Console

Use SQL Console to inspect schemas, run DDL, read data, and export results.

Select where SQL runs

1. Select ClickHouse or ElasticQuery under Compute.
2. Select a Node.
3. Select a Database.
4. Enter SQL and select Run.

ClickHouse supports normal read, write, and DDL operations. ElasticQuery is read-only.

Browse tables

The table browser lists tables in the selected database. Select a table name to prepare a query, or select DDL to inspect its definition.

On ElasticQuery:

• All data identifies a logical table that reads all synchronized node copies;
• Synced from node identifies a table backed by one ClickHouse node.

Results

Results remain in a horizontally scrollable table. Long string values wrap so the full value can be inspected. Use:

• Chart when the result contains suitable numeric data;
• Download CSV to save the current result;
• History to reopen a query previously run in this browser.

The Console limits the displayed result size. Add an explicit LIMIT for large queries.

ElasticQuery eligibility

Only MergeTree-family tables created with SETTINGS table_disk = true are synchronized to ElasticQuery. A normal table is still queryable through ClickHouse.