Configure Looker to query ClickHouse through a JDBC connection string, set up SSL, and verify schema access.
Provide Host, Port (default 8123 for HTTP or 9000 for native), Database, Username, Password, and JDBC Parameters. Set Dialect to clickhouse
in Looker’s Admin → Connections panel.
Use jdbc:clickhouse://HOST:PORT/DATABASE?user=USER&password=PWD&ssl=true&sslmode=none
. Replace placeholders with actual values. ssl=true
avoids plain-text credentials.
Pick 8123 (HTTP) for ease or 9440 for HTTPS. Use 9000 only if Looker’s dialect supports native port in your version.Always match protocol and port.
Click “Test” in Looker. A green check means Looker can authenticate, open the schema, and run SELECT 1
on ClickHouse.
Create a view
for each fact or dimension. Reference ClickHouse tables directly, e.g., sql_table_name: Orders ;;
. Use LookML derived tables for aggregates.
Set connect_timeout
and socket_timeout
JDBC parameters to 30 000 ms. Enable max_execution_time
for runaway queries.Use materialized views in ClickHouse for Looker Explores.
.
Looker can read them as strings. Use arrayJoin
or JSONExtract
in derived tables for analysis.
Yes. Point JDBC parameters to sslkey
, sslcert
, and sslrootcert
files on the Looker host.
Add max_execution_time=30
(seconds) in the JDBC string or set it globally in ClickHouse.