Connection guide

Connect ClickHouse

ClickHouse uses SQL-like GRANT syntax for read-only access.

Create a dedicated user

CREATE USER with a secure password.

CREATE USER unitylayer_user IDENTIFIED BY 'your_secure_password';

Grant database access

GRANT SHOW DATABASES ON *.*

GRANT SHOW DATABASES ON *.* TO unitylayer_user;

Grant read permissions

GRANT SELECT ON your_database.*

GRANT SELECT ON your_database.* TO unitylayer_user;

Grant table access (optional)

Restrict to specific tables if needed.

-- For specific tables:
GRANT SELECT ON your_database.your_table TO unitylayer_user;

-- For all tables in a database:
GRANT SELECT ON your_database.* TO unitylayer_user;

Verify user permissions

SHOW GRANTS FOR unitylayer_user

SHOW GRANTS FOR unitylayer_user;

When setup is complete, open Connect database in the data catalog to enter credentials and test the connection.