Data Source Types
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.
-
-
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.