Greenplum

Connect a Greenplum database to Lakehousecat using a connection URI.

Connection Fields

Field	Required	Description
Connection URI	Yes	Full connection string. Example: greenplum://user:password@host:5432/database
Use SSH	No	Enable if the database is behind an SSH bastion host. See SSH Tunneling.

Prerequisites

• Admin or Builder role in Lakehousecat
• A Greenplum user with SELECT access to the target schemas and tables
• Default port: 5432

Notes

• Greenplum is PostgreSQL-compatible — use the greenplum:// URI scheme in Lakehousecat.
• Use a read-only database user to follow the principle of least privilege.
• Incremental Load is supported; use a timestamp column (e.g., updated_at) as the merge key.

Next Steps

After creating the datasource, go to the Operations tab to trigger semantic extraction.