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 schema(s) containing the tables
  • SELECT on all relevant tables in those schemas

For example, after creating the user, grant access to an analytics schema and its existing tables:

sql
GRANT USAGE ON SCHEMA analytics TO supersimple;
GRANT SELECT ON ALL TABLES IN SCHEMA analytics TO supersimple;

Replace analytics and supersimple with your schema and user names. Apply the appropriate grants when adding new tables. Shared databases and external schemas may require additional permissions; see the Amazon Redshift grant examples.

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

After entering your connection details, test your connection to continue setup.