Connection guide

Connect PostgreSQL

PostgreSQL connections require a dedicated user with CONNECT, schema USAGE, and SELECT on tables.

Create a dedicated user

Create unitylayer_user with a secure password.

CREATE USER unitylayer_user WITH PASSWORD 'your_secure_password';

Grant connection permission

Allow the user to connect to your database.

GRANT CONNECT ON DATABASE your_database TO unitylayer_user;

Grant schema usage

Grant USAGE on the schemas Unity Layer needs to read.

GRANT USAGE ON SCHEMA public TO unitylayer_user;
GRANT USAGE ON ALL SCHEMAS IN DATABASE your_database TO unitylayer_user;

Grant read permissions

Grant SELECT on all tables, including future tables via default privileges.

GRANT SELECT ON ALL TABLES IN SCHEMA public TO unitylayer_user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO unitylayer_user;

Verify user permissions

List roles and grants to confirm setup.

\du unitylayer_user

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