-- For local development (disable verification like Kafka's skip_ssl_cert_check)
CREATE EXTERNAL TABLE clickhouse_table
SETTINGS type = 'clickhouse', address = 'localhost:9440', database = 'default',
secure = 'true', ssl_verify_mode = 'none',
user = 'never', password = 'never', table = 'never'
-- For custom CA (like Kafka's ssl_ca_cert_file)
CREATE EXTERNAL TABLE clickhouse_table
SETTINGS type = 'clickhouse', address = 'localhost:9440', database = 'default',
secure = 'true', ssl_ca_cert_file = '/proton-enterprise/clickhouse-test/certs/ca.crt',
user = 'never', password = 'never', table = 'never'
-- For production (default - uses system trust store)
CREATE EXTERNAL TABLE clickhouse_cloud
SETTINGS type = 'clickhouse', address = 'your-cluster.clickhouse.cloud:9440', database = 'default',
secure = 'true', -- ssl_verify_mode defaults to 'relaxed'
user = 'user', password = 'pass', table = 'mytable'
-- For local development (disable verification like Kafka's skip_ssl_cert_check)
CREATE EXTERNAL TABLE clickhouse_table
SETTINGS type = 'clickhouse', address = 'localhost:9440', database = 'default',
secure = 'true', ssl_verify_mode = 'none',
user = 'never', password = 'never', table = 'never'
-- For custom CA (like Kafka's ssl_ca_cert_file)
CREATE EXTERNAL TABLE clickhouse_table
SETTINGS type = 'clickhouse', address = 'localhost:9440', database = 'default',
secure = 'true', ssl_ca_cert_file = '/proton-enterprise/clickhouse-test/certs/ca.crt',
user = 'never', password = 'never', table = 'never'
-- For production (default - uses system trust store)
CREATE EXTERNAL TABLE clickhouse_cloud
SETTINGS type = 'clickhouse', address = 'your-cluster.clickhouse.cloud:9440', database = 'default',
secure = 'true', -- ssl_verify_mode defaults to 'relaxed'
user = 'user', password = 'pass', table = 'mytable'