Troubleshoot Your Connection
Summary of Content
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.
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.