ClickHouse Setup Guide

Prerequisites

• A ClickHouse Cloud service.
• The default user credentials for the service. The password is shown only once, when the service is created.

Setup Guide

Step 1: Create a dedicated user (Recommended)

1. Log in to the ClickHouse Cloud console and open your service.

2. Click + to open a new query.

3. Run the following statements as the default user. Replace <password> with a strong password.

   CREATE USER matia_user IDENTIFIED BY '<password>';
   
   GRANT CURRENT GRANTS ON *.* TO matia_user;

4. Additionally, you can revoke access to certain databases from the matia_user. For example, by executing the following statement, we restrict access to the default database:

   REVOKE ALL ON default.* FROM matia_user;

5. Make a note of the Username and Password — you'll need them to configure Matia.

Step 2: Find your hostname and port

1. In the ClickHouse Cloud console, select your service and click Connect.
2. Select Native.
3. Copy the Hostname. It follows the format <service>.<region>.<provider>.clickhouse.cloud.
4. Make a note of the Port. For most services, this is 9440.

Step 3: Connect ClickHouse in Matia

1. Under Authentication, enter:
   • Hostname — the hostname you copied in Step 2.
   • Port — the port you noted in Step 2.
   • Username — the user you created in Step 1, for example matia_user.
   • Password — the password for that user.
2. Enter an Asset Name.
3. (Optional) Enter a Description.
4. (Optional) Assign Tags.
5. Select an Owner.
6. Verify that your ClickHouse service is successfully connected by clicking on Test Connection.
7. Click Connect.