ClickHouse
The ClickHouse connector for Rudol allows you to connect your self-hosted or cloud ClickHouse datawarehouse.
info
Your ClickHouse server instance must be publicly available through a resolvable DNS hostname or public IPv4, see Security Guidelines to know more on how to apply firewall restrictions
Connection parameters
| Name | Type | Description |
|---|---|---|
| Hostname | text | Publicly accesible ClickHouse server DNS hostname |
| Port | number | Server port number (8443 by default) |
| User | text | ClickHouse user name, see User permissions |
| Password | password | ClickHouse user password |
User permissions
In order to grant Rudol the necessary permissions to fetch your database metadata we recommend you to create a new ClickHouse user with access restricted only to selected databases.
Here is a sample code to create a new user for Rudol with minimal permissions for metadata scan:
CREATE USER 'rudol_user' IDENTIFIED BY 'super-secret-password';
-- Grant SELECT and SHOW permissions
GRANT SELECT, SHOW ON system.* to 'rudol_user';
GRANT SELECT ON <database_name>.* to 'rudol_user';
info
If you want to use Data Quality features you have to grant SELECT to each table you'd like to validate.
Read more about access permissions here.