ClickHouse

A ClickHouse connection is used to support exporting/loading data from your Upsolver tables into ClickHouse.

Syntax

CREATE CLICKHOUSE <connection_identifier> 
    CONNECTION_STRING = '<connection_string>' 
    USER_NAME = '<user_name>'
    PASSWORD = '<password>' 
    [ COMMENT = '<comment>' ]

Jump to

• CONNECTION_STRING

• USER_NAME

• PASSWORD

• COMMENT

Connection options

CONNECTION_STRING — editable

Type: text

The connection string to use when connecting to ClickHouse. Syntax should be as follows:

protocol://host[:port][/database][?param[=value][&param[=value]][#tag[,tag]]

The ClickHouse documentation for creating a connection string can be found here.

USER_NAME — editable

Type: text

The user for authenticating to the database.

PASSWORD — editable

Type: text

The password to use for authentication.

COMMENT — editable

Type: text

(Optional) A description or comment regarding this connection.

Example

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