Create a connection
- Click + New Connection.
- Choose the role: Source or Destination.
- Choose PostgreSQL.
- Fill the connection fields.
- Click Test Connection.
- Save after the test succeeds.
Source connections
Source users should have read access to the schemas and tables you plan to include.Destination connections
Destination users should have write access to pre-created destination tables. MantrixFlow validates those tables during pipeline runs.Good operating habits
- Re-test connections after credential rotation.
- Keep source users read-only where possible.
- Keep destination table ownership and permissions explicit.