Sigma supports connecting via SSH for Postgres and Redshift.
To enable SSH connections, send the following information to your system admin:
Sigma’s public key: attached below
Sigma IP addresses:
How to Connect via SSH
- Save Sigma’s SSH Public Key, attached below.
- Whitelist Sigma IPs through your firewall: `184.108.40.206` and `220.127.116.11` .
- 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.