--- title: "Integrating Kafka with ClickHouse using SSL/SASL: A Technical Retrospective" url: https://daily.dev/posts/integrating-kafka-with-clickhouse-using-ssl-sasl-a-technical-retrospective-1bxbpihww source_url: https://coinsbench.com/integrating-kafka-with-clickhouse-using-ssl-sasl-a-technical-retrospective-be9d75864340 type: article source: "Coins Bench" published: 2026-05-30T21:33:56.054Z updated: 2026-05-30T21:34:26.137Z tags: ["clickhouse", "apache-kafka", "data-streaming"] reading_time: 3 upvotes: 21 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Integrating Kafka with ClickHouse using SSL/SASL: A Technical Retrospective **[Coins Bench](https://daily.dev/sources/coinsbench)** · 3 min read · 21 upvotes · 0 comments ## Summary Connecting ClickHouse to a SASL_SSL-secured Kafka cluster fails when trying to pass SSL certificate paths directly in CREATE TABLE SQL statements — ClickHouse returns a Code 115 UNKNOWN_SETTING error. The solution is to move SSL/SASL configuration (CA cert path, security protocol, SASL mechanism) into a server-side XML config file under /etc/clickhouse-server/config.d/, keeping infrastructure concerns separate from SQL-level application settings. Once the server config is in place, the Kafka table definition becomes clean and straightforward, with only performance-tuning parameters like kafka_num_consumers and kafka_max_batch_size remaining in the SETTINGS block. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Kafka and AI walk into a bar...](https://daily.dev/posts/kafka-and-ai-walk-into-a-bar--yswehdxe0) · SoftwareMill · 0 upvotes · 0 comments --- Tags: [#clickhouse](https://daily.dev/tags/clickhouse), [#apache-kafka](https://daily.dev/tags/apache-kafka), [#data-streaming](https://daily.dev/tags/data-streaming) [View this post on daily.dev](https://daily.dev/posts/integrating-kafka-with-clickhouse-using-ssl-sasl-a-technical-retrospective-1bxbpihww)