Clickhouse SQL GUI Builder

ClickHouse is an open-source column-oriented DBMS for online analytical processing. Pulse is a free SQL Application builder, it allows creating real-time updating charts/tables and linking them interactively. It works on every operating system, with every database including Clickhouse.

Start Clickhouse
Connecting to Clickhouse
Querying Clickhouse

Setting up a Clickhouse connection in Pulse

Start Clickhouse

Clickhouse can either be ran locally or you can use Clickhouse Cloud. To keep this tutorial simple we opted for cloud. Simply start a small service in your chosen region. The connection details should be provided, similar to shown:

Connecting to a Server

When you first open Pulse click on the menu options Server->Add Server or on the add server button on the toolbar.
Then set the details:

Server Type: Clickhouse.com
Note for Host you MUST include https://
Host: https://uiize2id4m.europe-west4.gcp.clickhouse.cloud
Port: 8443
Username: default
Password: ~aFNF9sgseN_Y
Click Add

Sending Queries

Copy paste the below code into the SQL editor. Then highlight everything and press Ctrl + e to run that code.

CREATE DATABASE IF NOT EXISTS helloworld;

DROP TABLE IF EXISTS helloworld.my_first_table;
CREATE TABLE helloworld.my_first_table (
        user_id UInt32,
        message String,
        timestamp DateTime,
        metric Float32
    ) ENGINE = MergeTree() PRIMARY KEY (user_id, timestamp);
    
INSERT INTO helloworld.my_first_table (user_id, message, timestamp, metric) VALUES
    (101, 'Hello, ClickHouse!',                                 now(),       -1.0    ),
    (102, 'Insert a lot of rows per batch',                     yesterday(), 1.41421 ),
    (102, 'Sort your data based on your commonly-used queries', today(),     2.718   ),
    (101, 'Granules are the smallest chunks of data read',      now() + 5,   3.14159 );
SELECT * FROM helloworld.my_first_table;

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

Well Done!

You have now got Pulse querying your database successfully. Next we recommend you try our Clickhouse dashboard tutorial. Or we have many more tutorials to help you learn how to build an interactive data application.

We want to make Pulse the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.

Clickhouse Play Database

The easiest way to play with Clickhouse is to use the Play Database. For this database you must use the URL format:

jdbc:ch:https://play.clickhouse.com:443?compress=0&sslmode=none

SELECT * FROM covid WHERE date>'2020-03-11' AND location_key='NL_NH_0417' ORDER BY date LIMIT 2000;

select file_time,position from github_events LIMIT 10

select * from blogs.forex_usd LIMIT 10;

Common Problems

SQLException: Connect timed out, server ClickHouseNode

Possibly the server is using SSL and you haven't got the correct details. Try turning off SSL/compression.

jdbc:ch:https://uiize2id4m.europe-west4.gcp.clickhouse.cloud:8443?compress=0&sslmode=none