Skip to content

Connect to Amazon Redshift ​

1. Create a read-only database user ​

Create a dedicated database user for Supersimple with read-only access. Grant the following permissions:

  • USAGE on the target database
  • USAGE on the schema(s) containing the tables
  • SELECT on all relevant tables in those schemas
  • (Optional) SELECT on information_schema to allow schema discovery

Note: Granting access to information_schema allows Supersimple to automatically discover and display the database schema, including tables, columns, and data types.

2. Configure network access ​

Allow connections from the following IP addresses:

  • 35.228.195.204/32
  • 35.228.203.89/32

Configuration steps:

  1. In the AWS Console, navigate to Amazon Redshift → Clusters
  2. Select the cluster and go to the Properties tab
  3. Under Network and security settings, click on the VPC security group
  4. In the Inbound rules tab, click Edit inbound rules
  5. Add two rules with the following configuration:
    • Type: Redshift (or Custom TCP)
    • Port: 5439 (or a custom port)
    • Source: Add each IP address above
  6. Save the rules

3. Set up connection in Supersimple ​

Provide the following information in the Supersimple connection setup page:

  • Host: The Redshift cluster endpoint
  • Port: 5439 (or a custom port)
  • Database: The database name
  • Username: The read-only user created in Step 1
  • Password: The password for that user