To connect to your database you should first modify Redshift Cluster security group in order to whitelist Slemma’s inbound IP address.
- Open the AWS Management console.
- Select Clusters from the navigation panel on the left.
- Click on the cluster you want to connect.
- On the Configuration tab, find Cluster Security Groups field under Cluster Properties, and click on the cluster’s security group.
- Select one of the security groups.
- You will see a list of authorized connections. Click the blue Add Connection Type button at the top left corner.
- In the appeared window, select CIDR/IP from the Connection Type drop-down, and paste the Slemma address 22.214.171.124/32 in the CIDR/IP to Authorize field.
- Click the blue Authorize button to add Slemma to your security group.
To grab data for Slemma connection dialog window, navigate to your Redshift Configuration tab and copy&paste the necessary information.
Slemma connects to a database in a read-only mode. But Amazon Redshift disallows creating variables and temporary tables when connection is set to read-only. For this reason, we allow Redshift users to switch off the read-only mode in the Redshift Integration settings window under the Security tab if needed.
If you are seeing an error message like “Error: Transaction is read-only”, disabling the read-only mode should resolve this issue.