​
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

You may need to allowlist egress IPs for your Connectivity Region.

​
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.