ClickHouse DBA

The significance of access management

This article explains how to define SQL users and roles and then apply privileges and permissions to databases, tables, rows,...

File compression/decompression with ClickHouse Compressor utility

ClickHouse utility has a lot of tools to ease the operations. “clickhouse-compressor” is one of the tools used to perform...

ClickHouse String Functions – Part I

Introduction ClickHouse has three types of functions for string operations. These are: General Functions Searching Functions Replacing Functions I aimed...

How to generate random data for ClickHouse tables?

When performing tests, you may need to generate a large amount of test data for your tables to understand ClickHouse...

Writing Logs Into ClickHouse Table

In this article, we will transform ClickHouse logs to ndjson using vector.dev With ClickHouse 22.8 version, ClickHouse supports writing logs...