Appearance
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:
USAGEon the schema(s) containing the tablesSELECTon 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/3235.228.203.89/32
Configuration steps:
- In the AWS Console, navigate to Amazon Redshift → Clusters
- Select the cluster and go to the Properties tab
- Under Network and security settings, click on the VPC security group
- In the Inbound rules tab, click Edit inbound rules
- Add two rules with the following configuration:
- Type: Redshift (or Custom TCP)
- Port: 5439 (or a custom port)
- Source: Add each IP address above
- 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.
