Terraform example on how to use Cloud API​

How can I use API to manage clusters on ClickHouse Cloud?

One thing that often confuses new users is that ClickHouse generates a lot of log output, even under light load.

This is because the default log level is for historical reasons trace (instead of warning that would be the default in other databases).

The ClickHouse developers argue that trace provides a lot of insight in case goes wrong.

On the other hand, large volumes of logging means that system table system.text_log fills up quickly and needs to be merged in the background.

If the database runs stable, users may re-configure the log level.

In this guide, we'll learn how to add a column to an existing table.

Question​

How do I import GeoJSON with a nested object array?

Introduction​

Filtering a ClickHouse table by an array-column is a common task and the product offers a lot of functions to work with array-columns.

Introduction​

Sometimes you need to reingest all the data from one table to another.

For example, you might want to reingest data from a staging table to a production table. This article shows how to do this using the INSERT INTO statement.

Users may see cases where their query is slower than expected, in the belief they are ordering or filtering by a primary key. In this article we show how users can confirm the key is used, highlighting common reasons its not.

The following steps can be used to enable SSL for a single ClickHouse Server using Let's Encrypt, a free, automated, and open Certificate Authority (CA) designed to make it easy for anyone to secure their websites with HTTPS. By automating the certificate issuance and renewal process, Let's Encrypt ensures websites remain secure without requiring manual intervention.

ClickHouse has no pivot operator, but we can achieve similar behavior using aggregate function combinators and, in particular, the ones with the -Map suffix.

Setup steps to expose a private RDS via AWS PrivateLink to ClickPipes.