Connection guide
Connect Amazon Redshift
Redshift uses PostgreSQL-compatible permissions. Create a dedicated user with SELECT access on the schemas you want to query.
Create a dedicated user
Create unitylayer_user with a secure password.
CREATE USER unitylayer_user WITH PASSWORD 'your_secure_password';Grant database access
Grant access to your target database.
GRANT CREATE ON DATABASE your_database TO unitylayer_user;Grant schema usage
Grant USAGE on required schemas.
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 tables in those schemas.
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
Confirm the user and grants are in place.
SELECT * FROM pg_user WHERE usename = 'unitylayer_user';When setup is complete, open Connect database in the data catalog to enter credentials and test the connection.