Amazon Redshift

Connect an Amazon Redshift cluster to Lakehousecat using a connection URI.

Connection Fields

Field	Required	Description
Connection URI	Yes	Full connection string. Example: redshift+psycopg2://user:password@cluster.us-east-1.redshift.amazonaws.com:5439/database
Use SSH	No	Enable to connect through an SSH bastion host.

Prerequisites

• Admin or Builder role in Lakehousecat
• A Redshift user with SELECT access to the target schemas and tables
• The Redshift cluster endpoint and port (default: 5439)
• Network connectivity — ensure the Lakehousecat backend IP is allowed in the cluster's VPC security group

Notes

• Use a read-only database user to follow the principle of least privilege.
• For clusters in a private VPC, use the SSH tunnel option or configure VPC peering.
• 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.