Skip to main content
All CollectionsIntegrations 🔗
Connect Your Redshift Database to Rupert
Connect Your Redshift Database to Rupert

Step-by-step guide to link your Redshift database for data integration and alerts.

Adi Cohen avatar
Written by Adi Cohen
Updated over a month ago

Connecting your Amazon Redshift database to Rupert allows you to unlock powerful data insights and create meaningful alerts tailored to your needs. This guide provides instructions for both Redshift Serverless and Clustered setups, helping you configure access and securely share the necessary details with Rupert.

In this article we are going to cover the following topics:

Information Needed to Set Up the Connection in Rupert

In the Manage sources tab, you will need to provide the following information:

  1. Source Name: A custom name to identify this source in Rupert.

  2. Host: The endpoint of your Redshift workgroup or cluster (Serverless or Provisioned).

  3. Port: Automatically parsed from the URL entered in the "Host" field.

  4. Username & Password: Credentials for a Redshift user with read-only access to the tables/views Rupert needs.

  5. Database Name: The name of the database Rupert will access.

Step-by-Step Instructions for Redshift Serverless

1. Enable Public Access

  1. Navigate to the Serverless Dashboard in the AWS Redshift UI.

  2. Go to Workgroups, then select the workgroup you want to connect to Rupert.

  3. Under the Network and security section, click Edit.

  4. Check the box for Turn on publicly accessible.

  5. Click Save.

Note: If you encounter issues with public IPs being inaccessible, refer to AWS Documentation on Private and Public IP Access.

2. Retrieve the Workgroup Endpoint

  1. In the Serverless Dashboard, go to Namespaces/Workgroups.

  2. Locate the workgroup you wish to connect.

  3. Copy the endpoint and paste it into the Host field in Rupert.

3. Create a User with Appropriate Permissions

  1. Follow the AWS guide to Create a New User in Redshift.

  2. Assign this user read-only permissions for the tables or views Rupert should access.

4. Find the Database Name

  • The database name is the same as the one used for your PostgreSQL setup.

  • You can find it in the Serverless Dashboard under the Database tab of your namespace.

Step-by-Step Instructions for Redshift Provisioned Clusters

1. Enable Public Access

  1. Navigate to the Provisioned Clusters Dashboard.

  2. Select the cluster you want to connect to Rupert.

  3. Go to the Properties tab and find Network and security.

  4. If Publicly accessible is set to "Disabled":

    • Click Edit.

    • Check the box for Turn on publicly accessible.

    • Click Save.

2. Retrieve the Cluster Endpoint

  1. In the Cluster Dashboard, select your cluster.

  2. Copy the endpoint and paste it into the Host field in Rupert.

3. Create a User with Appropriate Permissions

  1. Follow the AWS guide to Create a New User in Redshift.

  2. Assign this user read-only permissions for the tables or views Rupert should access.

4. Find the Database Name

  • The database name is displayed in the Database section of your cluster details in the Redshift UI.

Troubleshooting Common Issues

Connection Refused

  • Ensure that Publicly Accessible is enabled for your workgroup/cluster.

  • Verify network configurations (e.g., security group rules, VPC settings).

  • Refer to this AWS Knowledge Base Article for additional guidance: Connection Refused Troubleshooting.

Did this answer your question?