ClickHouse DBA

Arrays in ClickHouse

Arrays are collections of items comprising similar data types. ClickHouse supports arrays as its column data type. The maximum allowed...

ProxySQL configuration for ClickHouse

ProxySQL is the high-performance SQL proxy, which has support for MySQL at its initial releases. From ProxySQL 1.4.3, it has...

Allow ClickHouse users to accept the connections from specific hosts

Securing user access is one of the crucial things in the Database environment. Restricting user access based on the needed...

Tuples in ClickHouse

Tuples are collections of items with heterogeneous data types. ClickHouse tuples are used with IN operators and in Lambda functions....

Working with nested data type in ClickHouse

The nested data type in ClickHouse is used to store multiple tabular data inside a table. This is useful when...