Appearance
Connect to ClickHouse
To get set up with ClickHouse, you'll need to provide the following information in the Supersimple connection setup page:
- URL: The HTTP(S) endpoint of your ClickHouse server (e.g.
https://your-instance.clickhouse.cloud:8443) - Database: The name of the database you want to connect to
- Username: Your ClickHouse username
- Password: Your ClickHouse password
The URL points at the HTTP interface of your ClickHouse server, and its scheme decides how Supersimple connects:
https://connects over TLS, and defaults to port8443when no port is givenhttp://connects over plain HTTP, and defaults to port8123when no port is given
Use https:// for ClickHouse Cloud and for any server that only accepts TLS on its HTTP interface — a plain http:// URL against such a port fails with 400 The plain HTTP request was sent to HTTPS port.
For ClickHouse Cloud, you can find the endpoint in your service's Connect view, under the HTTPS tab.
We recommend creating a dedicated read-only user for Supersimple. You can do this by running:
sql
CREATE USER supersimple IDENTIFIED BY 'your-secure-password';
GRANT SELECT ON your_database.* TO supersimple;