Connect to Redshift
Note: The following instructions apply to both Redshift and Postgres connections.
Summary of Content
- Admin privileges in your Sigma organization. Learn about account types.
- A Redshift data warehouse.
Connect to your Redshift Cluster
- Open your Admin Portal by selecting Administration in the user menu at the top right of your screen.
- Select the Connections page from the left-hand panel.
- Click the Create Connection button.
- Name your connection.
- Select Redshift under warehouse Type.
Once selected, you're prompted to define your Connection Credentials.
Learn more about finding these credentials.
- Enter your cluster Endpoint URL In the Host field.
Note: Sigma will connect from 126.96.36.199, 188.8.131.52, 184.108.40.206, and 220.127.116.11.
- Enter your cluster’s port number in the Port field.
- Enter your Redshift username in the User field.
- Enter your Redshift password in the Password field.
- Enter your cluster’s database name in the Database field.
- [optional] Enable TLS encryption on your connection.
- [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.
- [optional] Under Connection Features, you can set a connection timeout and/or enable write access.
- Click Create in the top right to create your configuration.
Locate your Redshift Cluster Credentials
- Go to the AWS Management Console.
- In the search bar, search and select Redshift.
You're directed to the Redshift dashboard.
- In the left-hand navigation panel, select Clusters.
- 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.