Clickhouse

Setup Clickhouse Integration To Mitzu

Overview

To connect Mitzu to a Clickhouse database, you’ll need the following:

• Host

• Port

• Database

• Username

• Password

Mitzu will encrypt these credentials and will never store them as plain text.

Clickhouse connection setup in Mitzu

1. Host

Your database’s IP address, or its domain name (e.g., abc.mydb.com).

Note on Host Format:

When entering URLs in our system, please include only the "Host" portion of the URL, omitting the "Scheme." This means you should not include parts like https:// at the beginning of the URL.

2. Port

Use the native protocol SSL/TLS port: 9440

3. Database

The name of the database you’re connecting to.

4. Username

The database username for the account that you want to use to connect to your database.

5. Password

The password for the username that you use to connect to the database.

6. URL Query Params

When constructing your URL with query parameters, please include the secure parameter and set its value to true. This ensures that your connection adheres to our security requirements.

secure=true

Whats next?

Add tables from Clickhouse. Follow here.