> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-parallel-read-in-order-multi-part.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
> Explo is an easy-to-use, open source UI tool for asking questions about your data.
# Connecting Explo to ClickHouse
export const CommunityMaintainedBadge = () => {
return ;
};
export const Image = ({img, alt, size = "lg", background}) => {
const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
const backgroundColor = background === "white" ? "white" : background === "black" ? "rgb(31 31 28)" : undefined;
return ;
};
Customer-facing analytics for any platform. Designed for beautiful visualization. Engineered for simplicity.
Goal
In this guide you will connect your data from ClickHouse to Explo and visualize the results. The chart will look like this:
**Add some data**
If you don't have a dataset to work with you can add one of the examples. This guide uses the [UK Price Paid](/get-started/sample-datasets/uk-price-paid) dataset, so you might choose that one. There are several others to look at in the same documentation category.
To connect to ClickHouse with HTTP(S) you need this information:
| Parameter(s) | Description |
| - | - |
| `HOST` and `PORT` | Typically, the port is 8443 when using TLS or 8123 when not using TLS. |
| `DATABASE NAME` | Out of the box, there is a database named `default`, use the name of the database that you want to connect to. |
| `USERNAME` and `PASSWORD` | Out of the box, the username is `default`. Use the username appropriate for your use case. |
The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console.
Select a service and click **Connect**:
Choose **HTTPS**. Connection details are displayed in an example `curl` command.
If you're using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.
1. Sign up for an Explo account.
2. Click on the Explo **data** tab on the left hand sidebar.
3. Click **Connect Data Source** in the upper right hand side.
4. Fill out the information on the **Getting Started** page
5. Select **ClickHouse**
6. Enter your **ClickHouse Credentials**.
7. Configure **Security**
8. Within ClickHouse, **Whitelist the Explo IPs**.
`54.211.43.19, 52.55.98.121, 3.214.169.94, and 54.156.141.148`
1. Navigate to **Dashboard** tab on the left side nav bar.
2. Click **Create Dashboard** in the upper right corner and name your dashboard. You've now created a dashboard!
3. You should now see a screen that is similar to this:
1. Get your table name from the right hand sidebar under your schema title. You should then put the following command into your dataset editor:
`SELECT * FROM YOUR_TABLE_NAME
LIMIT 100`
2. Now click run and go to the preview tab to see your data.
1. From the left hand side, drag the bar chart icon onto the screen.
2. Select the dataset. You should now see a screen like the following:
3. Fill out the **county** in the X Axis and **Price** in the Y Axis Section like so:
4. Now, change the aggregation to **AVG**.
5. We now have average price of homes broken down by price!
Learn more
Find more information about Explo and how to build dashboards by visiting the Explo documentation.
