Holistics Joins House Mates, ClickHouse’s New Partner Ecosystem

Holistics has been selected for House Mates - ClickHouse's structured partner ecosystem of 60+ ISVs, consulting firms, and services providers.

House Mates is designed to ensure ClickHouse customers get the best possible experience across the tools they pair with ClickHouse. The program gives partners like Holistics a structured pathway to deepen their ClickHouse integration, access technical support and sandbox environments, and collaborate with ClickHouse's field team on joint customer success. The goal is simple: when a ClickHouse customer picks a partner tool, that tool should work exceptionally well with ClickHouse.

While the formal program is new, Holistics has been working with ClickHouse-based teams for years, and the ClickHouse team has been recommending us to their customers for just as long. House Mates puts a formal structure around a relationship that's already been producing results.

Years of working with ClickHouse teams

Holistics was one of the first BI platforms to build a native ClickHouse connector, and we've been refining it across multiple ClickHouse versions since. This early investment created a compounding effect: ClickHouse users found us, adopted us, and the ClickHouse team started recommending us during vendor evaluations.

Over time, this turned into a steady stream of ClickHouse-sourced customers across different industries and regions:

• Pharmacy networks in Australia ingesting millions of prescription and inventory events into ClickHouse, then using Holistics to build embedded dashboards for franchise owners tracking stock levels and dispensing trends in real time.
• E-commerce platforms in Europe running clickstream and order data through ClickHouse at sub-second query speeds, with Holistics powering the customer-facing analytics their merchants rely on for revenue reporting and cohort analysis.
• Insurance companies in Latin America consolidating claims and policy data into ClickHouse for actuarial workloads, then using Holistics to deliver governed, scheduled reports to regional underwriting teams. The industries varied, but the technical setup converged: ClickHouse as the analytical warehouse, Holistics as the BI and reporting layer on top.

Why Holistics is the right BI tool for ClickHouse

After years of working with ClickHouse-based teams across industries and regions, we've developed a clear picture of what these teams need from a BI layer. ClickHouse users are a specific kind of team. They chose a columnar database for its raw query speed and cost efficiency. They tend to prefer infrastructure they control, workflows defined in code, and tools that stay out of their way.

Here's what we've learned about why Holistics fits.

Native ClickHouse connectivity. Holistics connects over HTTP/HTTPS directly. You enter your host, port, credentials, toggle SSL for ClickHouse Cloud, and you're querying in minutes. Most BI tools either skip ClickHouse support entirely or require ODBC workarounds that add instability and configuration overhead. ClickHouse users treat native connectivity as a hard filter during evaluation. If a tool needs ODBC, it doesn't make the shortlist.

The strongest semantic layer in the category. Most semantic layers handle first-order analysis well enough: slice, filter, group-by, standard dashboard monitoring. The breakdown appears on normal follow-up questions: cohort comparisons, period-over-period analysis, rolling windows, cross-grain ratios. Those are routine questions for any ClickHouse team running analytical workloads, and they expose the ceiling of conventional semantic layers.

Holistics uses AML (Analytics Modeling Language), a code-first semantic layer where data models, relationships, metrics, and business logic are defined as version-controlled code. AML supports expressive metric definitions that handle nested aggregations, cohort logic, and period comparisons inside the governed layer, keeping that logic inside the governed layer instead of scattering it across dbt models, dashboard formulas, or one-off SQL. Paired with AQL, a composable semantic query language, Holistics keeps even complex follow-up questions within the semantic layer rather than forcing analysts to work around it.

AI-powered analytics built on the semantic layer. Holistics is an AI analytics platform, and the semantic layer is what makes the AI actually work. Because AML captures the business logic, metric definitions, and relationships in a structured, machine-readable format, Holistics' AI features can generate accurate queries, suggest relevant metrics, and build visualizations that respect the data model. AI without a semantic layer hallucinates. AI on top of a well-defined semantic layer produces answers you can trust.

Caching that complements ClickHouse's speed. ClickHouse handles analytical queries fast. Holistics adds a smart cache layer on top, so repeated dashboard loads avoid re-executing the same queries. When your dashboards serve hundreds of external users, this keeps both query costs and latency predictable at scale.

Embedded analytics as a first-class capability. Almost every ClickHouse customer we've worked with uses Holistics for external-facing analytics: dashboards embedded in their own product, shared via password-protected links, or delivered as scheduled reports. They're buying BI to serve their customers.

Holistics handles this through embeddable iframes, shareable links with row-level security, white-labeling, scheduled delivery, and dynamic database routing for multi-tenant setups where each customer queries their own data source. For teams that want to go further, Holistics also offers a whitelabel AI chatbot that can be embedded directly into your product, giving your end users a natural-language interface to their data without building it from scratch.

SQL escape hatch when you need it. ClickHouse users are SQL-literate. They want a modeling layer for structure and reuse, but they also want the ability to write raw SQL for complex edge cases like unusual date logic, multi-fact joins, and custom aggregations. Holistics supports both: AML for the semantic layer, pure SQL query models when you need full control.

Getting started

If you're running ClickHouse and want to try Holistics, the setup is short:

1. Create a read-only ClickHouse user with SELECT on your target tables and system.* for schema detection.
2. Add a ClickHouse data source in Holistics: host, port (8443 for Cloud, 8123 for self-hosted), database, and credentials.
3. Enable SSL if you're on ClickHouse Cloud.
4. Test and save.

For instances behind a firewall or inside a VPC, Holistics supports both IP allowlisting and reverse SSH tunnels, so you can connect without exposing your database publicly.

We've published a full connection guide covering prerequisites, permissions, network configuration, and known limitations. And if your use case is embedded or external analytics on ClickHouse, that's the scenario we know best in this ecosystem, and the one where we can help you move fastest.

---

Holistics is an AI analytics platform with a code-based semantic layer. ClickHouse is a fast, open-source columnar database. Together, they give data teams a governed, high-performance stack from warehouse to dashboard.