Building Beautiful Interactive Dashboards with Grafana and ClickHouse

Grafana and ClickHouse are a very popular combination for interactive dashboards on big data. In this presentation, we'll show you how to install Grafana on ClickHouse, and lead you through the steps to create nice-looking dashboards of your own. The talk covers how Grafana dashboards work.

Read More
Goodbye XML, hello SQL! ClickHouse User Management Goes Pro

Access control is one of the essential features of database management. Starting in late 2019 ClickHouse contributor Vitaly Baranov began to introduce robust, full-featured Role Based Access Control (RBAC). As a result of this work–which[...]

Read More
ClickHouse is Apache 2.0

Open source licenses are in the news again. Elastic recently changed the licensing for ElasticSearch and Kibana from Apache 2.0 to a choice of Server Side Public License (SSPL) or the non-open source Elastic license. Like most open source licensing changes, this one prompted a lot of discussion.

Read More
Connecting to Altinity.Cloud with the ClickHouse Web UI

Did you know that ClickHouse has a built-in Web UI? The Web UI is a simple but extremely useful feature Alexey Milovidov added to ClickHouse in October 2020. In this short article I’m going to[...]

Read More
The ClickHouse Community

Editor’s Note: This blog article is also posted on the official ClickHouse blog. We would like to thank Alexey Milovidov, Ivan Blinkov, and Alexander Zaitsev for their kind assistance. One of the great “features” of[...]

Read More
Harnessing the Power of ClickHouse Arrays – Part 3

This final article completes our tour of array capabilities. We’ll survey functions for array map and reduce operations, demonstrating behavior and commenting on performance. This is an opportunity to dig further into lambdas, which are critical for using arrays effectively.

Read More
Harnessing the Power of ClickHouse Arrays – Part 2

ClickHouse arrays combine neatly with GROUP BY aggregation. We show how arrays track sequences and offer a couple of ways to do funnel analysis.

Read More
Harnessing the Power of ClickHouse Arrays – Part 1

ClickHouse contributors regularly add analytic features that go beyond standard SQL. This design approach is common in successful open source projects and reflects a bias toward solving real-world problems creatively. Arrays are a great example.

Read More
Introduction to High-Velocity Analytics Using ClickHouse Arrays

Arrays are a prominent ClickHouse SQL extension that can accelerate query speed up to 100x in well-chosen use cases. This webinar introduces ClickHouse arrays and shows how to use them effectively. We provide examples of idiomatic usage and guides you on use cases where you should immediately reach for arrays. Please join us to become a power user of this popular ClickHouse feature.

Read More
What we learned by closing a $4M investment from Accel

I’m pleased to share the news that Altinity has raised a $4M seed investment from Accel, led by Dan Levine. We are honored by Accel’s trust and delighted to work with Dan. We plan to use the investment to roll out our new Altinity.Cloud platform and to strengthen ClickHouse into the best analytic database on the planet.

Read More
ClickHouse Data Integration — September 2020 Meetup Report

Our last ClickHouse SF Bay Area meetup was on September 10th and focused on data integration. This turned out to be a popular subject.  We had well over 100 signups with 59 people in attendance.[...]

Read More
Conference Slides. Five Great Ways to Lose Data on Kubernetes (And How to Avoid Them)

As databases and stateful apps rapidly adopt Kubernetes, the reality of accidental data loss isn't far behind. Robert Hodges, Altinity CEO, will give listeners tools to push through the paranoia and ensure happy experiences with cloud native data.

Read More