ClickHouse

This quickstart shows you how to create a ClickHouse connection.

Create a connection to ClickHouse

The following instructions show how to create a basic connection to ClickHouse.

Your connection is persistent, so you won't need to re-create it for every job. The connection is also shared with other users in your organization.

Here's the code to create a connection your ClickHouse database:

// Syntax
CREATE CLICKHOUSE CONNECTION <connection name>
    CONNECTION_STRING = 'http://<host_name>:8123/<db_name>'
    USER_NAME = 'your username'
    PASSWORD = 'your password';

// Example
CREATE CLICKHOUSE CONNECTION my_clickhouse_connection
    CONNECTION_STRING = 'http://upsolver_demo:8123/sales_orders'
    USER_NAME = 'dbuser1'
    PASSWORD = 'mypassword';

This code creates a connection named my_clickhouse_connection that uses the sales_orders database.

---

Learn more

Please see the SQL command reference for ClickHouse for the full list of connection options, and examples.