Skip to main content

Setting Up Amazon Redshift as a Data Source in GrowthBook

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

note

This guide focuses on Redshift Serverless, but the steps are similar for provisioned Redshift instances.

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
Redshift details

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. Redshift 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.
Redshift Inbound Rules
note

Enabling public access makes your database accessible from the internet. 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;
tip

If your data is in a different schema (e.g., analytics), replace public with your schema name.

  1. 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.

Redshift GrowthBook connection

🚀 Now, GrowthBook can securely query your Redshift database!