Terraform example on how to use Cloud APIThis covers an example of how you can use terraform to create/delete clusters using the APIJan 28, 2025 · 5 min read
How do I remove the default user?Learn how to remove the default user when running ClickHouse Server.Jan 16, 2025 · 2 min read
Why is ClickHouse logging so verbose by default?Learn why the ClickHouse developers chose to set a verbose logging level by default.Jan 10, 2025 · 2 min read
Adding a column to a tableIn this guide, we'll learn how to add a column to an existing table.Dec 18, 2024 · 4 min read
Importing GeoJSON with a deeply nested object array“Importing GeoJSON with a deeply nested object array“Dec 18, 2024 · 5 min read
How to filter a ClickHouse table by an array-column?Knowledgebase article on how to filter a ClickHouse table by an array-column.Dec 17, 2024 · 3 min read
How to insert all rows from one table to another?Knowledgebase article on how to insert all rows from one table to another.Dec 17, 2024 · 2 min read
Why is my primary key not used? How can I check?Covers a common reason why a primary key is not used in ordering and how we can confirmDec 12, 2024 · 6 min read
How to Enable SSL with Let's Encrypt on a Single ClickHouse ServerLearn how to set up SSL for a single ClickHouse server using Let's Encrypt, including certificate issuance, configuration, and validation.Dec 11, 2024 · 6 min read
Can you PIVOT in ClickHouse?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.Dec 11, 2024 · 7 min read