Introduction
In this article, we show you how to connect your Astrato workspace to Clickhouse via PostgreSQL interface. It's designed to be a quick process and easy to follow.
ClickHouse supports the PostgreSQL wire protocol, which allows you to use Postgres clients to connect to ClickHouse. In a sense, ClickHouse can pretend to be a PostgreSQL instance - allowing you to connect a PostgreSQL client application to ClickHouse that is not already directly supported by ClickHouse (for example, Amazon Redshift).
Checklist
When you're setting up your data connection, you'll be asked to enter information about your data source. We've listed all the information & other requirements here:
Setup PostgreSQL Interface for ClickHouse: See documentation from ClickHouse
Data connection: Hostname, Port
Database Credentials: User name, Password
SSL Credentials: SSL mode - default set at 'Disable' (HTTP) - please amend as required to meet your organization's security policy.
Create New Connection
Select Data in the sidebar
Create Data to open the Create New Data Source screen
Click on the PostgreSQL icon
A dialogue box displays to Connect to a PostgreSQL (Figure 1)
Complete the required fields in the connection dialogue box, and click Test Connection
Select database: enter the database name, Data Source/connection name, and click Connect.
If the connection is successful and the data source is created, the Data View Editor opens.
Please note: if a duplicate is created, a timestamp is added to the data source name.
Cloud NAT IP addresses
prod-astrato-io-prod-nat-ip-0
34.142.11.11
prod-astrato-io-prod-nat-ip-1
34.142.68.232
Figure 1: Create New Connection - dialogue box image