PostgreSQL
Connect a PostgreSQL database to Lakehousecat using a connection URI.
Connection Fields
| Field | Required | Description |
|---|---|---|
| Connection URI | Yes | Full connection string including credentials, host, port, and database name. Example: postgresql://user:password@host:5432/mydb |
| Use SSH | No | Enable if the database is behind an SSH bastion host. When enabled, SSH settings fields appear: Host, Port, Username, Password, Private Key, and Private Key Passphrase. See SSH Tunneling. |
Prerequisites
- Admin or Builder role in Lakehousecat
- A PostgreSQL user with read access to the schemas and tables you want to expose
- Network connectivity from the Lakehousecat backend to the database (direct or via SSH)
Notes
- Use a read-only database user to follow the principle of least privilege.
- For large databases, configure schema and table filters in the Filters tab after creation to limit the scope of semantic extraction.
Next Steps
After creating the datasource, go to the Operations tab to trigger semantic extraction.