How it works
ClickHouse is a database for analyzing large amounts of data. Connect it to turn your business data into dashboards and reports. 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
- Search and filter records
- Summarize totals and trends over time
- Break down results by date, region, or category
- Look up the databases, tables, and fields available to the connection
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 +, select Integrations, then choose ClickHouse.Enter the HTTPS endpoint, Username, and Password provided by your ClickHouse administrator, then select Connect. In ClickHouse Cloud, find the address under Connect and include its port if shown.
2
Describe your use case
Tell Zite which data and results you need. For example, “Show daily orders for the last 90 days, with a region filter.”Zite can look up the available tables and fields; tell it which ones to use.
3
Test and publish
Compare a small report with the same data in ClickHouse. Check totals, date ranges, and filters before sharing it.Click Publish in the upper-right corner to make the ClickHouse features available in your live app.
Common use cases
With a ClickHouse connection, you can create apps like:- Sales Dashboards: Summarize orders and revenue by period.
- Operations Reports: Compare activity across locations or teams.
- Data Explorers: Let teammates search and filter large datasets.
- Usage Reports: Show trends in product activity over time.
Important notes
- Read-only account: Use a dedicated ClickHouse user with read-only access to the databases your app needs. Permissions come from that user; connecting an administrator account is not a read-only guarantee.
- Connection address: Copy the HTTPS address from ClickHouse’s connection settings. If a test fails, ask your administrator to check the address, password, and network access.
- Large results: Ask Zite to filter or summarize data instead of loading every row. If a result is too large, narrow the date range or show totals.
- Missing data: Check that the connected user can access the required database and table. Choose which data your app exposes to its users.
Need help with this integration? Contact support@zite.com.