Choose the right schema approach for JSON data in ClickHouse — typed columns, hybrid, native JSON, or String storage

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

Knowledgebase article on how to filter a ClickHouse table by an array-column.

ClickHouse doesn't have a PIVOT clause, but we can get close to this functionality using aggregate function combinators. Let's see how to do this using the UK housing prices dataset.

There is an issue where data in dictionaries may not be visible immediately after creation.

Learn how to create a ClickHouse dictionary using string keys and values from a MergeTree table as the source, with examples of setup and usage.

This KB article explores whether Materialized Views are inserted synchronously

Learn how to check if a projection is used in ClickHouse queries by testing with sample data and using EXPLAIN to verify projection usage.