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 semantic layer is created.
Please note: if a duplicate is created, a timestamp is added to the data source name.
Creating a Dynamic Data Connection
Dynamic data connection is good when connecting users to different projects but using one data model.
The main use case for dynamic connections is combining it with embedded analytics.
To serve OEM solutions.
Setting up a dynamic data connection is similar to setting up a JWT connection.
Follow these steps:
Create a new ClickHouse connection (check the use dynamic connection checkbox)
Fill in the needed information.
URL
Port
User
Password
These credentials will be the default credentials.
Click Test connection
Add more users (users need to be part of the Astrato tenant) to the connection settings.
Define the key to authenticate and the project to use in the connection for each user.
Click next
Define who has the right to use the connection.
Click connect
Known Limitation
Only users who use the same credentials and project as the defaults will be able to edit and see the data in the Semantic Layer Editor
The dynamic data connection is only used in published workbooks.
Users who aren't defined in the dynamic connection table won't be able to see data in the workbook.
Known Limitations:
Writeback and CSV uploads are not supported.