SQLTools ClickHouse Driver

ClickHouse driver for SQLTools VS Code extension.

Installation

• Directly from VS Code by searching @tag:sqltools clickhouse or just clickhouse;
• From marketplace.

Usage

After installation you will be able to explore tables and views, run queries, etc. For more details see SQLTools documentation.

Limits

• Don't use ; at the end of the query. Since that driver uses @apla/clickhouse library it automatically adds the FORMAT statement after query. In this case SQLTools thinks that you are sending multiple queries, which not supported (yet).

• Use LIMIT when selecting from table which stores more than 100 000 (about) records.