> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hunch.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# ClickHouse

> Connect your ClickHouse database to Hunch

This guide will help you connect your ClickHouse Cloud service to Hunch in just a few minutes.

***

## ✅ What You'll Need

* **ClickHouse Cloud Account** at [clickhouse.com](https://clickhouse.com)
* **Access to your ClickHouse service**

***

## 1️⃣ Get Your ClickHouse Connection Details

First, let's gather your connection information from ClickHouse Cloud:

### Step 1: Navigate to ClickHouse Cloud

1. Go to [clickhouse.com](https://clickhouse.com) and log into your account
2. Select your desired ClickHouse service from the dashboard

<img src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/clickhouse-integration/select_service.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=b007fffd3fed22a9035bf791c87159e4" alt="Select your ClickHouse service" style={{ width: "400px", borderRadius: "8px", margin: "16px 0" }} width="518" height="352" data-path="public/images/clickhouse-integration/select_service.png" />

### Step 2: Access Connection Details

1. Click on **"Connect"** in the left sidebar

<img
  src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/clickhouse-integration/connect.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=fc3f2748a2ab6d73c2d9e883a1dd90fe"
  alt="Click Connect in the sidebar"
  style={{
    height: "500px",
    maxWidth: "300px",
    borderRadius: "8px",
    margin: "16px 0",
}}
  width="468"
  height="874"
  data-path="public/images/clickhouse-integration/connect.png"
/>

2. In the **"Connect with"** dropdown, select **"Python"**
3. Copy the following connection details from the displayed code:
   * **Host** (the server address)
   * **Username**
   * **Password**

<img src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/clickhouse-integration/creds.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=014c94021699915ffe3a08077fa94f43" alt="Copy connection credentials from Python example" style={{ width: "400px", borderRadius: "8px", margin: "16px 0" }} width="1282" height="1080" data-path="public/images/clickhouse-integration/creds.png" />

<Info>
  **Password Not Visible?** If you see a message like "Cannot be displayed
  after initial creation. If you have lost your password, reset it," you'll
  need to either: - Ask your IT Manager for the password - Reset the password
  in your ClickHouse Cloud settings
</Info>

***

## 2️⃣ Connect to Hunch Platform

Now let's connect your ClickHouse service to Hunch:

### Step 1: Navigate to Hunch

1. Go to [app.hunch.dev](https://app.hunch.dev)
2. Click on the **Hunch logo** at the top-left corner
3. Select **"Connect your data"**

<img src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/clickhouse-integration/hunch_connect_data.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=330be1c603bb62ca330f956f0627dca4" alt="Click Connect your data in Hunch" style={{ width: "400px", borderRadius: "8px", margin: "16px 0" }} width="598" height="354" data-path="public/images/clickhouse-integration/hunch_connect_data.png" />

### Step 2: Configure ClickHouse Integration

1. Find the **ClickHouse** service and click **"Configure"** next to it

<img src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/clickhouse-integration/hunch_clickhouse_configurations.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=dc3626e33b44540d2e0fc48e60645e31" alt="Configure ClickHouse integration" style={{ width: "400px", borderRadius: "8px", margin: "16px 0" }} width="1002" height="1398" data-path="public/images/clickhouse-integration/hunch_clickhouse_configurations.png" />

2. Fill in the connection details you gathered from ClickHouse Cloud:
   * **Host**: The host address from your ClickHouse connection details
   * **Username**: The username from your ClickHouse connection details
   * **Password**: The password from your ClickHouse connection details
   * **Database**: You can change this from "default" if you have multiple databases

### Step 3: Test and Save Connection

1. Click **"Test Connection"** at the bottom of the form
2. Wait for the connection test to complete successfully

<img src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/clickhouse-integration/test_connection.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=645f87dbbae0bd2fb8fe0c0b6e8eb4cd" alt="Test the ClickHouse connection" style={{ width: "400px", borderRadius: "8px", margin: "16px 0" }} width="620" height="124" data-path="public/images/clickhouse-integration/test_connection.png" />

3. Once the connection test passes, click **"Submit"** to save your integration

***

## 🎉 You're All Set!

That's it! Your ClickHouse database is now connected to Hunch. You can now mention your ClickHouse database in your queries and Hunch will be able to access your data.

***

## 🚨 Troubleshooting

### Common Issues

**Connection Test Failed**

* Double-check that you copied the host, username, and password correctly from ClickHouse Cloud
* Ensure your ClickHouse service is running and accessible
* Verify that there are no typos in the connection details

**Password Issues**

* If the password is not visible in ClickHouse Cloud, you may need to reset it
* Contact your IT Manager if you don't have permission to reset the password

**Database Access**

* Make sure the user has the necessary permissions to access the database you're trying to connect
* Try using "default" as the database name if you're unsure

***

## 📞 Need Help?

If you encounter any issues during setup, our support team is here to help:

* **Email**: [support@hunch.dev](mailto:support@hunch.dev)
* **Slack Community**: [Join our Slack](https://join.slack.com/t/hunchdevcommunity/shared_invite/zt-38sihc6ph-zwQUOA4OD5TUIdDXxpjK0w)

We typically respond within a few hours during business hours.