Adding ClickHouse Connection
First create a user along with relevant role for waii to connect to clickhouse database. To create user along with appropriate role follow the guidelines here
Adding a New Database:
In the 'Manage Warehouses' section:
- Click on 'Add New', select type as 'ClickHouse'
- A form will be presented to you. Fill out the necessary details for the connection.
- Host/port:
- Enter host:port of the MySQL server. For example,
localhost:8123.
- Enter host:port of the MySQL server. For example,
- Database:
- Enter one of the databases you want to connect to.
- Username:
- Enter the username to connect to the database.
- Password:
- Enter the password to connect to the database, it can be empty if the database doesn't require a password.
- Host/port:
- After entering the details, click on Submit.