Setting Up Amazon Redshift as a Data Source in GrowthBook

This document outlines the steps needed to add your Redshift database to GrowthBook.

Connecting Amazon Redshift to GrowthBook allows you to analyze experiment data and metrics directly from your data warehouse.

1: Find Connection Details

1. In the AWS Management Console, navigate to Amazon Redshift → Serverless.
2. Click on Workgroup configuration, select your workgroup.
3. Under General information, locate the Endpoint, which looks like this:

default-workgroup.1234567890.us-east-1.redshift-serverless.amazonaws.com:5439/dev

This string comprises the following parts:

• Host: default-workgroup.1234567890.us-east-1.redshift-serverless.amazonaws.com
• Port: 5439
• Database Name: dev

2: Configure Security settings

1. Go to AWS Console → Amazon Redshift → Serverless → Workgroups.
2. Click on your Workgroup and scroll to Network and Security.
3. Click Edit and check Turn on Publicly accessible.
4. Click Save Changes.
5. Click on the VPC security group link.
6. Select the Security Group matching your Workgroup.
7. Edit Inbound Rules:
   • Protocol: TCP
   • Port: 5439
   • Source: 52.70.79.40/32 (GrowthBook’s IP)
8. Click Save Changes.

Ensure your security group settings are restrictive.

3: Create a Read-Only User

To prevent unauthorized changes, use a dedicated read-only user for GrowthBook.

1. Open AWS Query Editor or your preferred SQL client.
2. Run the following:

CREATE USER growthbook_user WITH PASSWORD 'securepassword';  
GRANT SELECT ON ALL TABLES IN SCHEMA public TO growthbook_user;  
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO growthbook_user;

3. Use this user when connecting GrowthBook.

4: Add Redshift as a Data Source in GrowthBook

1. In GrowthBook, go to Settings → Data Sources.

2. Click Add Data Source and choose Redshift.

3. Enter the details from Step 1:

   • Host: (Your Workgroup Endpoint for Serverless or Cluster Endpoint for Provisioned)
   • Port: 5439
   • Database: (Your database name, e.g., dev)
   • User: growthbook_user
   • Password: (Your secure password)
   • Require SSL: Recommended but may depend on your Redshift setup.

4. Click Next to test the connection.

🚀 Now, GrowthBook can securely query your Redshift database!