Amazon Redshift

Estimated reading time: 1 min

To connect to your database you should first modify Redshift Cluster security group in order to whitelist Slemma’s inbound IP address. 

  1. Open the AWS Management console.
  2. Select Clusters from the navigation panel on the left.
  3. Click on the cluster you want to connect.
  4. On the Configuration tab, find Cluster Security Groups field under Cluster Properties, and click on the cluster’s security group.

  5. Select one of the security groups.
  6. You will see a list of authorized connections. Click the blue Add Connection Type button at the top left corner.

  7. In the appeared window, select CIDR/IP from the Connection Type drop-down, and paste the Slemma address in the CIDR/IP to Authorize field.

  8. 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.

Was this article helpful?
Dislike 0
Views: 1945