15 Sept 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 Technical Copywriter

Use cases for ClickHouse® illustration

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.

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.

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.

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.

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 Beta is available now, and 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 beta product page and check the product documentation here.

If you have any feedback or questions, hit us up on Twitter, or send an e-mail to beta@aiven.io.

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 blogs

All things open source, plus our product updates and news in a monthly newsletter.

Subscribe to the Aiven newsletter