Connection guide
Connect MariaDB
MariaDB uses the same user management syntax as MySQL for read-only ingestion users.
Create a dedicated user
Create unitylayer_user with a secure password.
CREATE USER 'unitylayer_user'@'%' IDENTIFIED BY 'your_secure_password';Grant required permissions
Grant SELECT on your_database.* to the user.
GRANT SELECT ON your_database.* TO 'unitylayer_user'@'%';
FLUSH PRIVILEGES;Grant schema access (optional)
Fine-grain access to specific schemas if needed.
-- If using specific schemas:
GRANT SELECT ON your_database.your_schema.* TO 'unitylayer_user'@'%';
FLUSH PRIVILEGES;Verify user permissions
Run SHOW GRANTS to confirm.
SHOW GRANTS FOR 'unitylayer_user'@'%';When setup is complete, open Connect database in the data catalog to enter credentials and test the connection.