Connecting ClickHouse to External Data Sources using the JDBC Bridge

Connecting ClickHouse to External Data Sources using the JDBC Bridge

ClickHouse is never used as a standalone – it integrates with other data sources and exposes query results to applications. Upstream data for OLAP is sometimes in relational databases like MSQL SQL Server. The JDBC and ODBC bridges provide a flexible way to connect and fetch data, especially in environments like Kubernetes.

My First ClickHouse Cluster on GCP

My First ClickHouse Cluster on GCP

As regular readers of this blog are aware, Altinity.Cloud now supports Google Cloud Platform, also known as GCP. I recently took the new capability out for a spin to see what it’s like to run ClickHouse there.

Meet the Open Source Analytics Community at OSA Con on Nov 2

Meet the Open Source Analytics Community at OSA Con on Nov 2

Our goal was to bring together a diverse set of presentations from the entire open source analytic community, rather than focusing on single projects or applications. We’ve succeeded and here’s just a sample of talks you’ll hear. 

Cloud-Native Data Warehouses: A Gentle Intro to Running ClickHouse on Kubernetes

Cloud-Native Data Warehouses: A Gentle Intro to Running ClickHouse on Kubernetes

Kubernetes is a powerful platform for big data and is particularly well-suited for ClickHouse. If you have been wondering about trying Kubernetes, this webinar is for you. The first half introduces Kubernetes basics while the second half focuses on ClickHouse. You’ll learn everything you need to start grappling with big data on Kubernetes. Please join us!

ClickHouse Object Storage Performance: MinIO vs. AWS S3

ClickHouse Object Storage Performance: MinIO vs. AWS S3

ClickHouse now fully supports both AWS S3 and MinIO as S3-compatible object storage services. In this comparison, we will test the performance of AWS S3 and MinIO when used to store table data from two of our standard datasets: the OnTime dataset; and the New York Taxi dataset.

Integrating ClickHouse with MinIO

Integrating ClickHouse with MinIO

In November 2020, Alexander Zaitsev introduced S3-compatible object storage compatibility with ClickHouse. In his article ClickHouse and S3 Compatible Object Storage, he provided steps to use AWS S3 with ClickHouse’s disk storage system and the S3 table function. Now, we are excited to announce full support for integrating with MinIO, ClickHouse’s second fully supported S3-compatible[…]

Monitoring ClickHouse on Kubernetes with Prometheus and Grafana

Monitoring ClickHouse on Kubernetes with Prometheus and Grafana

The ClickHouse Kubernetes operator is great at spinning up data warehouse clusters on Kubernetes. Once they are up, though, how can you see what they are actually doing? It’s time for monitoring!
In this article we’ll explore how to configure two popular tools for building monitoring systems: Prometheus and Grafana. The ClickHouse Kubernetes operator includes scripts to set these up quickly and add a basic dashboard for clusters.