ClickHouse
Features
Using jdbc note you can use quix to query ClickHouse. You will be able to execute multiple queries in parallel, explore the db tree, visualize and download the results into csv.
Setup
To setup ClickHouse note you have to perform the following :
1. Pick new name and update .env
Add/update following properties to .env file to configure your new note
| Variables | Meaning | Example |
|---|---|---|
MODULES | list of registered notes | foo,boo,prod,qa |
MODULES_FOO_ENGINE | note type | jdbc |
MODULES_FOO_DRIVER | jdbc driver class | ru.yandex.clickhouse.ClickHouseDriver |
MODULES_FOO_URL | jdbc url | jdbc:clickhouse://localhost:8123/test |
MODULES_FOO_USER | db username | user |
MODULES_FOO_PASS | db password | pass |
MODULES_FOO_SYNTAX | syntax marker | ansi_sql |
example of clickhouse jdbc note that will be named foo in the UI
MODULES=<comma separated list of your modules>,foo
MODULES_FOO_ENGINE=jdbc
MODULES_FOO_DRIVER=ru.yandex.clickhouse.ClickHouseDriver
MODULES_FOO_URL=jdbc:clickhouse://localhost:8123/test
MODULES_FOO_USER=your-user
MODULES_FOO_PASS=your-password
MODULES_FOO_SYNTAX=ansi_sql