# How to build Dashboards from ClickHouse data

Learn how to build dashboards from ClickHouse data using Draxlr's no-code BI tool. Connect, query, visualize, and share your data effortlessly.

By Vivek Published on 2024-07-25

[ClickHouse](https://clickhouse.com/) is a fast and highly efficient columnar database management system.

Top 8 features of ClickHouse:

1. **High Performance**: Remarkable speed, capable of processing billions of rows and petabytes of data per second.
2. **Columnar Storage Format**: Efficiently stores data by columns, allowing for substantial compression and quicker data access.
3. **Scalability**: Supports both vertical and horizontal scaling to manage large datasets and high query loads in distributed clusters.
4. **Real-time Data Ingestion**: Enables immediate data processing and analysis, making it ideal for real-time applications.
5. **SQL Compatibility**: Utilizes a familiar SQL query language, making it user-friendly for those experienced with SQL databases.
6. **Advanced Compression**: Employs sophisticated compression algorithms to minimize storage requirements and enhance I/O performance.
7. **Distributed Query Processing**: Efficiently distributes data and executes queries in parallel across multiple nodes for improved performance.
8. **High Availability**: Ensures data consistency and system reliability through data replication and automatic failover mechanisms.

## Using Draxlr to build Dashboards from ClickHouse data

>Draxlr is a no-code BI tool that allows you to create dashboards, receive data alerts, and embed dashboards on customer-facing websites.
>
>Draxlr has partnered with ClickHouse to allow ClickHouse users to build dashboards and get data alerts.

Here is a quick video walkthrough of how to build a dashboard from **ClickHouse data** in **Draxlr**:

[How to build Dashboards from ClickHouse data](https://www.youtube.com/watch?v=pkguAynvnlw)

## Connecting ClickHouse with Draxlr

In ClickHouse, you can have multiple organisations, and each organisation can have multiple projects. Each project has a Postgres Database. You can connect to a ClickHouse project database to generate insights into your data.

1. Login into Draxlr, visit the [Add Database page](https://app.draxlr.com/add-database), and select **ClickHouse**.  
   
2. Select the **platform** where your ClickHouse data is hosted. For this guide, let us assume you select ClickHouse Cloud.  
   
3. You will see a form to provide the database credentials. To get the database credentials login into your ClickHouse account and visit [https://console.clickhouse.cloud/](https://console.clickhouse.cloud/).  
   
4. ClickHouse Cloud can have multiple services under an organization, select the service which you want to connect.  
   
5. Click on **Connect** in the sidebar.  
   
6. On the Connect popup, select **MySQL** and copy the credentials to the Draxlr screen and hit **Next**.  
   
7. You can now select the database schema; by default, it is **default**.  
   
8. Now you can see the **list of tables**, and you can start exploring your data.

## Generating Queries and Visualizing the data

After connecting ClickHouse with Draxlr, you can create dashboards from your ClickHouse data.

1. Utilize Draxlr's no-code query builder to generate data with **filters, joins, sorting, summarizing**, and **grouping** options.
2. Visualize the resulting data using various graph options such as **bar, pie, line, area, tree-map, box-and-whisker**, and more.  
   
3. Once your graph setup is complete, save the query and add it to a dashboard.  
   
4. **Your dashboard is now ready!**  
   
5. Share the dashboard with your team and embed it in your customer-facing application.

Building dashboards from ClickHouse data with Draxlr is a straightforward process that leverages the power of both platforms. ClickHouse’s exceptional speed and scalability, combined with Draxlr's user-friendly interface and powerful visualization tools, enable you to gain valuable insights quickly and efficiently.

Whether you are managing large datasets or need real-time data analysis, this guide equips you with the knowledge to create and share dynamic dashboards that can enhance decision-making and drive business growth.

\- **Vivek**