Connecting to ClickHouse

  1. Open the connections page in preferences, see managing connections for more information.
  2. Click the Add new Connection button at the top of the connections page.
  3. Select ClickHouse from the list.
  4. Give a Connection name for your own internal reference.
  5. For Hostname, enter the hostname of your database server.
  6. For Port, use the default 8123, or enter the HTTP port used by your server.
    1. Note: for HTTPS, SSL options need to be toggled on.
  7. For Database, enter the name of your database.
  8. For Username and Password, enter the username and password for ClickHouse. These are optional.
  9. Toggle connection type for direct or cloud.
  10. Share the connection with your team.
  11. Configure SSH and SSL settings. These are optional.
  12. Hit Connect and you're all set!

alt text

Happy querying! 🍭

Cookie settings