Altinity Blog
Join over 2,000 ClickHouse® developers who receive our content directly in their inbox.
Webinars
The Analytics Easy Button, or: How to Deploy ClickHouse® Services with Terraform, Helm, or Argo CD
Push-button deployment is the holy grail of analytic platforms, but what’s the right path to fulfill your quest? In this webinar, we’ll show the standard ways to deploy scalable, open-source ClickHouse services on Kubernetes using Terraform, Helm, or Argo CD. ...
Blog
Squeezing JuiceFS with ClickHouse (Part 2): Bringing The Two Together
After installing JuiceFS, let's create a ClickHouse cluster and examine simple write and read performance to non-cached and cached ClickHouse standard S3 disks, as well as potential problems.
Blog
Squeezing JuiceFS with ClickHouse (Part 1): Setting Things Up in Kubernetes
See how to configure JuiceFS (a POSIX-compatible filesystem) as a disk to store data for ClickHouse MergeTree tables using clickhouse-operator and JuiceFS CSI Driver.
Blog
Into the Deep End: Learning SQL by Taking On Project Euler Puzzles (Part 2)
We continue learning SQL by solving math puzzles from Project Euler. This article shows how to extend ClickHouse capabilities with a user defined function (UDF) written in C++.
Blog
Into the Deep End: Learning SQL by Taking On Project Euler Puzzles (Part 1)
Solving math puzzles from Project Euler is a great way to learn about ClickHouse SQL, especially array functions. Math can also help you speed up queries by orders of magnitude.
Blog
OSA Con 2024: Submit Your Proposals on Open Source Analytics Today!
Get ready! The Open Source Analytics Conference is making a triumphant return from November 19th to 21st, 2024! We're on the lookout for exciting proposals. Submit a talk and join the list of world-class speakers.
Blog
Learning from Rockset: Avoiding the Dangers of Lock-in to Cloud Database-as-a-Services
The news that the popular Rockset cloud service is going to be terminated is shocking. So the question arises – is there a way to keep benefits of DBaaS service providers but remove the downside of vendor lock-in, including risks...
Blog
Using the Altinity Grafana Plugin for ClickHouse® in Grafana Cloud
The Altinity Grafana plugin for ClickHouse makes it easy to use the world's best open-source observability platform to visualize data from the world's best open-source analytics database. First released in 2017, the Altinity plugin is mature and the most popular,...
Webinars
Showing Beautiful ClickHouse® Data with the Altinity Grafana Plugin
The Altinity Grafana Plugin for ClickHouse® is the most popular plugin for creating dashboards on ClickHouse data with over 16M downloads. In this webinar, we’ll reveal how it works and how you can use it to create flexible, attractive dashboards...
Blog
ClickHouse® MergeTree on S3 – Keeping Storage Healthy and Future Work
The final article of our series on managing large datasets in ClickHouse MergeTree covers how to clean up orphan S3 files. We conclude with ideas for future improvements to S3 storage management.
Blog
ClickHouse® MergeTree on S3 – Administrative Best Practices
Our series on managing large datasets in ClickHouse MergeTree tables continues. In Part 2 we discuss best practices for S3 bucket configuration, storage policies, and MergeTree table administration.
Blog
ClickHouse® MergeTree on S3 – Intro and Architecture
ClickHouse datasets are getting big. Store MergeTree table data on S3 object storage to handle them economically and flexibly. Part 1 covers architecture and storage organization.