Before you connect
- A ClickHouse user with read access to the tables you want to query.
- Whether the server uses a secure (HTTPS) or plain (HTTP) interface.
- Network access from Genloop. If the server is behind a firewall, allow Genloop’s regional IP address. See Before you begin.
Connection fields
Encryption (TLS)
Keep Secure turned on to connect over HTTPS. This is the recommended setting and keeps traffic encrypted. Turn it off only when your server’s HTTP interface is not encrypted, for example inside a trusted private network. Set Port to match the interface you use. The port does not change automatically when you toggle Secure, so make sure it points at your server’s actual HTTP or HTTPS port.Connect through an SSH tunnel
If the server is not reachable directly, reach it through a bastion or jump host. Turn on Connect via SSH tunnel in the connection form and complete these fields.Permissions
Genloop only reads your data and never writes to your database. You can connect with any user that already has read access to the tables you select. If you want a dedicated read-only user for Genloop, ask your database administrator to set one up.Minimal read-only grant (for your database administrator)
Minimal read-only grant (for your database administrator)
Run this in your ClickHouse database:
Next steps
Connect a database
Back to the full connection flow.
Context Hub
View and edit the memory built from your connection.