MySQL
The MySQL connector for rudol allows you to connect your MySQL 8+ databases.
Your MySQL 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 MySQL server DNS hostname |
| Port | number | Server port number (3306 by default) |
| User | text | MySQL user name, see User permissions |
| Password | password | MySQL user password |
User permissions
In order to grant rudol the necessary permissions to fetch your database metadata we recommend you to create a new MySQL user with access restricted only to the information_schema database.
Here is a sample code to create a new user for rudol with minimal permissions for metadata scan:
CREATE USER 'rudol_user'@'52.6.101.83' IDENTIFIED BY 'super-secret-password';
GRANT SELECT ON information_schema.`COLUMNS` TO 'rudol_user'@'52.6.101.83';
GRANT SELECT ON information_schema.`TABLES` TO 'rudol_user'@'52.6.101.83';
If you want to use Data Quality features these permissions won't be enough: you'll have to grant SELECT to each table you'd like to run tests for, and CREATE TEMPORARY TABLE to run validations without locking tables.