Clickhouse

​

Intro

Find out more about Clickhouse here.

​

Necessary Credentials

• Hostname

  • The server where your database lives

  • Example: rds.amazonaws.com

• Port

  • The port the database server uses

  • Example: 9440

  • Note that Explo only supports the Clickhouse Native Protocol and other common Clickhouse ports will not work. Ensure the native protocol port over SSL is open. Find out more here.

  • Explo’s new data connector (FIDO) will be using the HTTPS port, 8443. Please ensure BOTH are allowlisted. If you are onboarding to a new workspace, the Explo team can help you determine which connector you are initially using.

• Database

  • Name of the database you are connecting Explo to
  • Example: acme_production

• Username

• Password

​

Allowlisting Explo’s IPs

​

SSH Tunnels

You can connect to Postgres databases via an SSH tunnel if necessary. Check out this section on SSH tunnels to see how.

​

Questions?

Please reach out to the Explo team at [email protected] if you have any questions.