ClickHouse

Step 1 - Connect to ClickHouse

Create a new connection

To create a new connection, do the following:

1. Click Create a new connection.

2. In the Connection String field, enter your connection in the following format:

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

   For more information, refer to the ClickHouse documentation.

3. Provide the Username and Password that will be used to authenticate to the database.

4. In Name your connection, enter the name for this connection. Please note this connection will be available to other users in your organization.

Use an existing connection

By default, if you have already created a connection, Upsolver selects Use an existing connection, and your ClickHouse connection is populated in the list.

For organizations with multiple connections, select the target connection you want to use.

Step 2 - Select where to ingest the data

To select the database where you want to ingest the data, do the following:

1. In Database Name, select the database where you want to ingest their data.

2. Enter the name of the new table in Name your new table.