Connecting to ClickHouse
- Open the connections page in preferences, see managing connections for more information.
- Click the
Add new Connection
button at the top of the connections page.
- Select
ClickHouse
from the list.
- Give a
Connection name
for your own internal reference. - For
Hostname
, enter the hostname of your database server. - For
Port
, use the default8123
, or enter the HTTP port used by your server.- Note: for HTTPS,
SSL options
need to be toggled on.
- Note: for HTTPS,
- For
Database
, enter the name of your database. - For
Username
andPassword
, enter the username and password for ClickHouse. These are optional. - Toggle connection type for direct or cloud.
- Share the connection with your team.
- Configure
SSH
andSSL
settings. These are optional. - Hit
Connect
and you're all set!
Happy querying! 🍭
Updated about 1 year ago