Skip to main content

Amazon Redshift

To add an Amazon Redshift connection, click on the Redshift option in Connect a data source section. connect

Connect​

Fill in the connection settings: redshift

Display name​

The display name for the database in the Wren AI interface.

Authentication Method​

Choose between two authentication methods: Username and Password and AWS Credentials.

Authentication Method Selection

Choose the authentication method that best fits your setup:

  • Username and Password: Use this if you have direct database credentials
  • AWS Credentials: Use this if you prefer AWS IAM authentication and have the cluster identifier

Host​

The endpoint URL of your Redshift cluster (e.g., my-cluster.abc123.us-east-1.redshift.amazonaws.com).

Port​

The port number for your Redshift cluster (default: 5439).

Username​

The Redshift database username.

Password​

The password for the Redshift database username.

Database​

The name of the database you want to connect to.

AWS Credentials required permissions

If you choose to use AWS credentials, you need to have at least AmazonRedshiftReadOnlyAccess policy granted.

Click Next to start connection and go to the next step.

Select Tables​

All tables of your connected Redshift database will be listed in this step. Select which tables you want to use in Wren AI. Each selected table will be created as a data model. See the Modeling documentations to learn more about what is data models. select_table

Define relationships​

Define the relationships among selected tables in this step. If you have defined primary keys and foreign keys in your Redshift dataset, we will list suggested relationships based on the information. If not, you can also add relationships by clicking the Add relationships button on the table blocks. relationship

Define following properties in a relationship:

  • From: Select the left side table and column of this relationship.
  • To: Select the right side table and column of this relationship.
  • Relationship Type: Select the type of relationship. add_relationship

Find more information about relationship in Modeling - Working with Relationships

You can also skip this step and finish connection.

Notice​

VPC and Security Group Configuration​

Make sure your Redshift cluster's VPC and security groups allow connections from the Wren AI instance. You may need to configure inbound rules to allow traffic on port 5439.