Skip to main content
Genloop connects to Amazon Redshift over a direct connection using a read-only user. It reads your schema and the tables you select, and never writes to your cluster.

​
Before you connect

  • A Redshift user with read access to the tables you want to query.
  • Network access from Genloop. If your cluster is in a VPC, allow Genloop’s regional IP address in the cluster’s security group. See Before you begin.

​
Connection fields

​
Connect through an SSH tunnel

If the cluster is not reachable directly, reach it through a bastion or jump host. Turn on Connect via SSH tunnel in the connection form and complete these fields.

​
Permissions

Genloop only reads your data and never writes to your cluster. You can connect with any user that already has read access to the tables you select. If you want a dedicated read-only user for Genloop, ask your database administrator to set one up.
Run this in your Redshift database:

​
Next steps

Connect a database

Back to the full connection flow.

Context Hub

View and edit the memory built from your connection.