ClickHouse

ClickHouse connection helps you connect to a ClickHouse database and run queries directly from Infoveave.

Adding a ClickHouse Connection

To create a new ClickHouse connection:

1. Go to the Database section.
2. Select ClickHouse from the available connectors.
3. Fill in the required connection details in the New ClickHouse Connection form.

Connection Parameters

When setting up a ClickHouse connection, you need to provide the following details:

Field	Description
Name	A unique name to identify your connection.
Port	Port number for ClickHouse (default is 8123).
Server	The ClickHouse server endpoint.
Username	Your ClickHouse username.
Password	The corresponding password for the username.
Database	The ClickHouse database you want to connect to.
Schema	The schema inside the database to be used (optional).

Steps to Validate and Save

1. After filling in the details, click Validate to verify the connection.
2. If validation succeeds, click Save to store the connection.
3. You can now use ClickHouse as a datasource in your Infoveave workspace.

Example Use Case

With a ClickHouse connection configured, you can:

• Run analytical queries on large datasets with high performance.
• Use ClickHouse SQL to analyze real-time and historical data.
• Connect ClickHouse data to Infoveave Infoboards for dashboards, reports, and interactive insights.