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 target databaseUSAGEon the schema(s) containing the tablesSELECTon all relevant tables in those schemas- (Optional)
SELECToninformation_schemato 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/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
