# ClickHouse

Steps to connect ClickHouse source to Dataflake is like connecting PostgreSQL to Dataflake. Read this [section](https://doc.dataflake.co/data-sources/postgresql) to learn more 

From the top navigation bar click on the ![](https://1648695648-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FygZlXb1uCVgursV03Kgn%2Fuploads%2FknFg5Q4SC7Z9FIpc9D60%2Fimage.png?alt=media\&token=8487c916-553f-4fe9-8f97-a11275189f89) icon.

Choose the **Connection strings** tab.

Click the **Add** button.

Enter the Name of your connection.

Select **ClickHouse** from the Connection type.

Enter your connection string.

1. **Hostname:** where your database is hosted
2. **Port:** default port number for ClickHouse is 8123
3. **Database:** name of your database
4. **User:** username of the Database you want to connect
5. **Password:** password of the Database you want to connect

Click **Next** then Click the **Complete** button to establish your Connection.

<figure><img src="https://1648695648-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FygZlXb1uCVgursV03Kgn%2Fuploads%2FhTJCJu5pmjh67rz9Fs7z%2Fimage.png?alt=media&#x26;token=dd635364-3b5b-414e-a87a-d5dcbe9e1f4b" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
You can paste the host url in the Host box to connect to your database quickly
{% endhint %}