ClickHouse

This guide helps you connect your ClickHouse database to Neo. With just a few connection details, you’ll be able to ingest and analyze high-performance analytics data.

Getting Started

To set up a connection to ClickHouse, you’ll need to fill in:

  • Your host, port, and database

  • Basic authentication (username and password)

Connection Details

Let’s break down what each field means:

1. Name

Pick a unique name for this ClickHouse source.

This is how you’ll recognize the source later when managing multiple sources.

Example:

  • clickhouse-prod

  • realtime-db

  • ad-analytics-clickhouse

This name must be unique across all your sources.

2. Host

The hostname or IP address of your ClickHouse server.

Example: clickhouse.internal.company.com or 192.168.1.100

3. Port

The port used to connect to ClickHouse.

Default is 9000 — change it only if your server uses a different port.

4. Database

The name of the ClickHouse database you want to connect to.

Example: events, analytics, logs_data

Authentication

ClickHouse uses basic authentication with a username and optional password.

Standard Authentication

This is the only supported method at the moment.

You’ll need:

User:

The username for authentication.

Default is default.

Password:

Password for the above user.

This field is optional and defaults to an empty string if not provided.

Passwords are masked in the UI for security.

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.