How it works
ClickHouse is a database built for fast analytics on very large amounts of data. Connect ClickHouse to your Zite app to turn that data into dashboards, charts, and reports—your app only reads your data and never changes it. App visitors don’t need their own ClickHouse logins—your app uses the connection you set up. By connecting ClickHouse, you can:- Show data in charts, tables, and dashboards
- Filter and search large datasets quickly
- Summarize trends and key metrics over time
- Break down data by date, location, or other categories
- Let Zite look up the databases and tables available, so you don’t need to describe your data
How to integrate ClickHouse into your app
1
Connect to ClickHouse
Ask Zite to connect your app to ClickHouse in the chat box. Alternatively, click + in the chat box, select Integrations, then choose ClickHouse.Enter your HTTPS endpoint (including the port), Username, and Password. In ClickHouse Cloud, you’ll find the endpoint under Connect. We recommend a dedicated user with read-only access to just the databases this app needs.
2
Describe your use case
Tell Zite how you want to use ClickHouse in your app. For example, “Build a dashboard of daily sign-ups for the last 90 days” or “Show a searchable table of orders with filters for region and date.”Zite looks up the databases and tables available to your connection and shows you what it finds. Tell it which data to use and what your app should display.
3
Test and publish
Test the ClickHouse features in your app to make sure the numbers and filters look right.Click
Publish in the upper right corner to deploy your changes and make the ClickHouse integration available in your live app.Common use cases
With a ClickHouse connection, you can create apps like:- Analytics Dashboards: Turn large datasets into charts, key metrics, and reports
- Reporting Tools: Summarize and break down data by date, location, or other categories
- Data Explorers: Let your team search, filter, and browse large datasets
- Activity Trackers: Show trends in events, usage, or sign-ups over time
- Customer Reports: Share specific metrics with clients in a portal
Important notes
- Read-only access: Your app can read data from ClickHouse but can’t add, change, or delete it.
- Use a dedicated user: Connect with a ClickHouse user that only has read access to the databases this app needs, rather than an admin account.
- HTTPS endpoint: Use the full HTTPS address, including the port (usually 8443). Zite tells you if the address or port you enter can’t be reached from an app.
- Result size: Each search returns up to 10,000 rows. For bigger datasets, ask Zite to filter or summarize the data, for example by showing totals per day.
- Permissions: If ClickHouse reports that the user doesn’t have enough permissions, update that user’s access in ClickHouse and try again.
Need help with this integration? Contact support@zite.com.