---
title: ClickHouse
description: Learn how to connect ClickHouse in Infoveave to query columnar data at scale for fast real-time analytics and reporting.
---

import { Aside, Steps } from '@astrojs/starlight/components';

# 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:
<Steps>
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.
</Steps>



## 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
<Steps>
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.
</Steps>


## 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.