Connect Zing Data to ClickHouse

[Edit this page](https://github.com/ClickHouse/clickhouse-docs/blob/main/docs/integrations/data-visualization/community_integrations/zingdata-and-clickhouse.md)

Community Maintained

[Zing Data](https://www.zingdata.com/) is a data exploration and visualization platform. Zing Data connects to ClickHouse using the JS driver provided by ClickHouse.

## How to connect[​](#how-to-connect "Direct link to How to connect")

1. Gather your connection details.

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.

2. Download or visit Zing Data

   - To use Clickhouse with Zing Data on mobile, download the Zing data app on [Google Play Store](https://play.google.com/store/apps/details?id=com.getzingdata.android) or the [Apple App Store](https://apps.apple.com/us/app/zing-data-collaborative-bi/id1563294091).
   - To use Clickhouse with Zing Data on the web, visit the [Zing web console](https://console.getzingdata.com/) and create an account.
3. Add a datasource

   - To interact with your ClickHouse data with Zing Data, you need to define a ***datasource***. On the mobile app menu in Zing Data, select **Sources**, then click on **Add a Datasource**.
   - To add a datasource on web, click on **Data Sources** on the top menu, click on **New Datasource** and select **Clickhouse** from the dropdown menu
4. Fill out the connection details and click on **Check Connection**.
5. If the connection is successful, Zing will proceed you to table selection. Select the required tables and click on **Save**. If Zing can't connect to your data source, you'll see a message asking your to check your credentials and retry. If even after checking your credentials and retrying you still experience issues, [reach out to Zing support here.](/cdn-cgi/l/email-protection#b1d9d4dddddef1d6d4c5cbd8dfd6d5d0c5d09fd2dedc)
6. Once the Clickhouse datasource is added, it will be available to everyone in your Zing organization, under the **Data Sources** / **Sources** tab.

## Creating charts and dashboards in Zing Data[​](#creating-charts-and-dashboards-in-zing-data "Direct link to Creating charts and dashboards in Zing Data")

1. After your Clickhouse datasource is added, click on **Zing App** on the web, or click on the datasource on mobile to start creating charts.
2. Click on a table under the table's list to create a chart.
3. Use the visual query builder to pick the desired fields, aggregations, etc., and click on **Run Question**.
4. If you familiar with SQL, you can also write custom SQL to run queries and create a chart.
5. An example chart would look as follows. The question can be saved using the three-dot menu. You can comment on the chart, tag your team members, create real-time alerts, change the chart type, etc.
6. Dashboards can be created using the "+" icon under **Dashboards** on the Home screen. Existing questions can be dragged in, to be displayed on the dashboard.

## Related content[​](#related-content "Direct link to Related content")

- [Documentation](https://docs.getzingdata.com/docs/)
- [Quick Start](https://getzingdata.com/quickstart/)
- Guide to [Create Dashboards](https://getzingdata.com/blog/new-feature-create-multi-question-dashboards/)

- [How to connect](#how-to-connect)- [Creating charts and dashboards in Zing Data](#creating-charts-and-dashboards-in-zing-data)- [Related content](#related-content)

Was this page helpful?