Introduction
In this article, we show you how to connect your Astrato workspace to ClickHouse It's designed to be a quick process and easy to follow.
Connection data required
When setting up your data connection, you'll need to know:
Data connection: Hostname, Port
Database Credentials: User name, Password
Creating the data connection to ClickHouse
Select Data in the sidebar
Select the Data Connection tab
Click on the New Data Connection button in the top right side of the screen.
Click on the ClickHouse icon.
A dialogue box displays to Connect to ClickHouse (Figure 1)
Complete the required fields in the connection dialogue box
Click Test Connection.
If the connection is successful, give the data connection a name and click Next.
Set the user access to the data connection and click connect.
A connection is created and a dataview is created.
Please note: if a duplicate is created, a timestamp is added to the data source name.
Known Limitations:
Writeback and CSV uploads are not supported.