# Connecting to ClickHouse

> This topic describes how to import data into ClickHouse, and how to use Live Connect. Sisense enables easy and quick access to databases, tables and views contained within ClickHouse.

*Source: https://docs.sisense.com/main/SisenseLinux/connecting-to-clickhouse.htm*

---

Last updated: June 10, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

[ClickHouse](https://clickhouse.com/docs) is an open-source, high-performance columnar database management system designed for online analytical processing (OLAP). It enables rapid analysis of large volumes of data in real time by using a column-oriented storage format and advanced data compression. ClickHouse is widely used for data warehousing, business intelligence, and log analytics, offering scalability, fault tolerance, and support for complex analytical queries with sub-second response times.

Sisense provides a native certified ClickHouse connector that enables you to connect directly to your ClickHouse database and import data into your ElastiCube or build a live data model. The ClickHouse connector is pre-installed and enables seamless integration with your ClickHouse environment, making it ideal for real-time analytics and high-performance queries.

## Importing ClickHouse Data

1. In the Model Editor of your data model, click ![+Data](https://docs.sisense.com/main/Resources/Images/+Data.png). The Add Data
   dialog box is displayed.
2. In the Choose Connector dialog box, [select an available **ClickHouse** managed connection](https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.md#AccessingandManagingAvailableConnections) or [create a new **ClickHouse** connection](https://docs.sisense.com/main/SisenseLinux/data-source-connection-management.md#CreatingNewConnections).

The Connector page appears.

![ClickHouseConnector](https://docs.sisense.com/main/Resources/Images/ClickHouseConnector_1032x755.png)

Enter the following details:

- Connection String -

  The ClickHouse [JDBC](https://clickhouse.com/docs/integrations/language-clients/java/jdbc) **connection string** is used to define how Sisense (or any client) connects to a ClickHouse database. It specifies the database location, port, optional database name, and any additional connection parameters.

  The [connection string syntax](https://clickhouse.com/docs/integrations/language-clients/java/jdbc#configuration) is `jdbc:clickhouse://<host>:<port>/<database>?<parameters>` where:

  - `<host>` – The hostname or IP address of the ClickHouse server.
  - `<port>` – The port number used for JDBC connections (default is 8123 for HTTP or 8443 for SSL connections in ClickHouse Cloud). For more information, see [ClickHouse Network ports](https://clickhouse.com/docs/guides/sre/network-ports).
  - `<database>` – (Optional) The name of the ClickHouse database to connect to. If omitted, the user’s default database is used.
  - `<parameters>` – (Optional) Additional connection properties, such as `ssl=true` or other configuration settings. Multiple parameters are separated by `&`.

- User and Password - [ClickHouse account details](https://clickhouse.com/docs/cloud/security/cloud-authentication#database-user-id--password) to be used for connection.

User/Password is the only Sisense supported authentication method.

Note:

If you have a previous custom JDBC-based implementation, Sisense strongly recommends switching to this native connector to benefit from the latest updates and certified version.