Skip to main content

​
How it works

Query large datasets and build analytics dashboards directly on your Zite app with ClickHouse. Your app can both read data from ClickHouse and send data to it. By connecting ClickHouse, you can:
  • Display data from in charts, tables, and dashboards
  • Filter and search large datasets in ClickHouse quickly
  • Show summaries, trends, and key metrics
  • Build custom reports and data views displayed in your Zite app
  • Send existing and new data from your Zite app to ClickHouse
You can start with a ClickHouse database that already has data or a blank one that you gradually fill with data from Zite. Over time, ClickHouse can accumulate large amounts of data that your app can query for heavy analytics, such as analyzing trends over years or breaking down millions of records.

​
How to analyze data

1

Connect to ClickHouse

In the chat box, request your app to be integrated with ClickHouse or click the plug icon  on the top right.
Image
Alternatively, you can click the plus icon + in the chat box to connect.Then, enter your HTTPS endpoint, username, and password.
Clickhouse Details 1
2

Enter use case

Tell Zite how you want to use ClickHouse in your app. For example, our Citizen Request Manager collects requests, while an existing ClickHouse table logs requests from another source. Let’s display a dashboard combining data from both.
Screenshot 2026 09 09 At 5 41 36 PM
3

Deploy and share

That’s it! Now we have a dashboard combining data from both.
Screenshot 2026 09 09 At 5 45 12 PM
Click Publish in the upper right corner and share your app.
Modify the theme or style the components of your app to personalize it or match it with your brand.

​
Common use cases

With a ClickHouse connection, you can create apps like:
  • Analytics Dashboards: Turn large datasets into charts, KPIs, and reports
  • Reporting Tools: Summarize and break down data by date, location, or other categories
  • Data Exploration Tools: Let users search, filter, and browse large datasets
  • Activity & Event Tracking: Store and analyze events from your app as they happen
  • Monitoring Tools: Track trends, metrics, and activity over time
Last modified on September 11, 2026