Aiven Blog

Sep 15, 2022

Use cases for ClickHouse®

Aiven for ClickHouse® is a fully-managed cloud data warehouse designed for exceptionally fast online analytical processing … what does that mean?


Andrew Hindle

|RSS Feed

Your friendly Aiven Copywriter

What does that mean?

What it means is, Aiven for ClickHouse is your one-stop tool for long-term storage of big volumes of data, and boasts an ideal toolkit for working with analytical data. This includes a huge number of functions, operators, compression codecs - and more. You’ve probably heard the term online analytical processing - OLAP. That’s what we’re talking about.

Open source ClickHouse is a columnar database offering extremely high throughput. To enjoy high-performance analytics for insights that help drive your business, integrate ClickHouse with Aiven for PostgreSQL® or Aiven for Apache Kafka®.

Now, let’s talk cases.

Offload analytics from your operational databases

Are you using Aiven for PostgreSQL as your operational database? Running analytical queries directly as part of your online transaction processing (OLTP) setup?

The problem: Running analytical queries - which can take hours - slows down performance for other users who just want to use the database to read, update or delete data. This impact on OLTP database performance can be considerable.

The solution: Offloading analytics queries from PostgreSQL to ClickHouse using its built-in integrations. Bringing analytical data into ClickHouse helps speed up queries and ensure that performance of OLTP requests in PostgreSQL is not affected.

Get real time analytical dashboards and reporting

Let's say you're in the business of capturing metrics. Lots of metrics. Server metrics, IoT devices, connected vehicle fleet data, you name it.

The problem: Your existing infrastructure can’t handle the increased telemetry load, and you’re experiencing limited functionality and aggregation capabilities in your current datastore.

The solution: Data can be quickly aggregated in real time to push the latest stats to dashboards. Efficient storage algorithms allow us to store a lot of data and enable users to easily generate trends and comparisons by looking at historical and recent data side by side.

Get high-performance analytics for your streaming and time series data

Do your applications need frequent time series data aggregation? Do you need to quickly store and process big data to display to your end users?

The problem: As data volumes / number of users increase, your existing stack performance hasn’t scaled to match - and queries are getting slower.

The solution: ClickHouse is ideal for fast aggregations on large datasets. ClickHouse’s vectorized query execution and compression work to greatly improve performance.

Does any of this sound like you?

If so, let’s get started! With us, you can set up clusters, deploy new nodes, migrate clouds and fork databases in just a few clicks. Better yet, you can monitor everything on a simple dashboard - or use Aiven for ClickHouse with Grafana to really bring your data warehouse to life.

Aiven for ClickHouse allows you to set up a fully managed cloud data warehouse in less than 10 minutes. If you’re a new customer, you'll need to create an Aiven trial account first.

  1. Log in to the Aiven Console.
  2. Create a new ClickHouse service.
  3. Load data to your newly created service.
  4. Use the built-in query editor to develop and test your analytics queries.
  5. Enjoy!

For more information, visit our Aiven for ClickHouse product page and check the product documentation here.

If you have any feedback or questions, hit us up on Twitter.

To get the latest news about Aiven and our services, plus a bit extra on all things open source, subscribe to our monthly newsletter!

Related resources