/sqltools-clickhouse-driver

SQLTools Driver for ClickHouse

Primary LanguageTypeScriptMIT LicenseMIT

SQLTools ClickHouse Driver

Visual Studio Marketplace Version License GitHub Workflow Status

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.