Knowledge Base

How to set up ClickHouse on Docker with ODBC to connect to a Microsoft SQL Server (MSSQL) database

Simple example flow for extracting JSON data using a landing table with a Materialized View

Example of mapping Windows Active Directory security groups to ClickHouse roles

Learn how to ingest data from a Kafka topic into ClickHouse using the Kafka table engine, materialized views, and MergeTree tables.

Commands to build LLVM and clang on Linux.

Learn how to search across nodes for tables with a wildcard.

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

How can I backup a specific partition in ClickHouse?

Learn how to ensure data consistency when reading from ClickHouse, whether you're connected to the same node or a random node.

Learn how to resolve the MacOS developer verification error when running ClickHouse commands, using either System Settings or the terminal.