Troubleshoot Your Connection

Summary of Content

Whitelist IP Addresses
      Snowflake
      Amazon Redshift
      Postgres
Permissions for the Snowflake User Role

Whitelist IP Addresses

In some cases, you may need to whitelist Sigma's IP addresses to successfully connect to your data. This step is required when your warehouse is closed to external connections (ie you have firewalls, security groups, or other IP-based security policies). 

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. 

Snowflake

How to whitelist IP address on Snowflake

Amazon Redshift

How to create an Amazon Redshift Security Group

Postgres

Sigma will need to be authenticated either at the Network level or through Client Authentication.
Client Authentication in Postgres

Permissions for the Snowflake User Role

Sigma uses the Snowflake user role specified on the connection. Make sure that you have the correct permissions granted to the user in Snowflake, or we won't be able to see the data in Sigma.
Learn more about granting permission to a user role in Snowflake.

If the connection uses OAuth with Snowflake, permissions are inherited per organization member from Snowflake. To troubleshoot permissions for an individual user or a Service Account user, confirm that they have access permissions on your Snowflake warehouse and that they inherit the intended role via your OAuth Provider.