Note: The following instructions apply to both Redshift and Postgres connections. 

Summary of Content

Requirements
Connect to your Redshift Cluster
Locate your Redshift Cluster Credentials
Related Resources

Requirements

Connect to your Redshift Cluster

  1. Open your Admin Portal by selecting Administration in the user menu at the top right of your screen.
  2. Select the Connections page from the left-hand panel.

    company apps
  3. Click the Create Connection button.
  4. Name your connection.
  5. Select Redshift under warehouse Type.
    Once selected, you're prompted to define your Connection Credentials.
    Learn more about finding these credentials.

    company apps

  6. Enter your cluster Endpoint URL In the Host field.
    Example: cluster.abcd.us-west-1.redshift.amazonaws.com
    Note: Sigma will connect from 44.229.241.60, 104.197.169.18, 104.197.193.23, and 54.188.54.135.
  7. Enter your cluster’s port number in the Port field.
  8. Enter your Redshift username in the User field. 
  9. Enter your Redshift password in the Password field.
  10. Enter your cluster’s database name in the Database field.
  11. [optional] Enable TLS encryption on your connection. 
  12. [optional] Connect to your instance via SSH Tunnel
    If you enable the SSH Tunnel, you're prompted to enter the Tunnel host and Tunnel port.
    Learn more about configuring a SSH Tunnel. 
    company apps
  13. [optional] Under Connection Features, you can set a connection timeout and/or enable write access.
  14. Click Create in the top right to create your configuration.

Locate your Redshift Cluster Credentials

  1. Go to the AWS Management Console.
  2. In the search bar, search and select Redshift.
    You're directed to the Redshift dashboard.
  3. In the left-hand navigation panel, select Clusters.
  4. Click on the cluster you would like to connect to Sigma.
    This directs you to the cluster page where you can find the required credentials to connect to Sigma.

Related Resources

Connect via SSH