Sigma supports connecting via SSH for Postgres and Redshift.
Summary of Content
- Admin privileges in your Sigma organization. Learn about account types.
- A Redshift or Postgres database.
SSH Server Parameters
To enable SSH connections, send the following information to your system admin.
Sigma’s public key: attached below
Sigma IP addresses: Sigma's egress IP addresses are listed on all individual connection pages in your Sigma Admin Portal. To view them, (1) Open your Admin Portal to the Connection page. (2) Select any connection or click 'Create Connection' (3) Look for the IP addresses listed under connection credentials.
Connect to Sigma via SSH
- Save Sigma’s SSH Public Key, attached below.
- Whitelist Sigma IPs through your firewall.
- Create an SSH user account called ‘sigmacomputing’.
- The user ‘sigmacomputing’ is configured to authenticate via public key. Authorize Sigma's public key according to the instructions of your SSH server.
- For most servers the SSH default port is 22, which is also the default port on Sigma. Check the port on your SSH server matches the port on Sigma.
- In Sigma, navigate to your connection’s page in the Admin Portal.
If you don’t already have a Redshift or Postgres connection set up, you will need to create a new connection.
- Under ‘Connection Credentials’, switch on ‘SSH Tunnel’.
- Set the Tunnel host (your IP address).
- Set the Tunnel port to match your SSH server.
Sigma defaults to port 22, as is common for most servers.
- If you are editing an existing connection, click ‘Save’.
OR if you are creating a new connection, continue with the create instructions.