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.
24.7K Impressions