Troubleshoot your connection

Summary of Content

Add Sigma IPs to the allowlist
      Snowflake
      Amazon Redshift
      Postgres
Permissions for the Snowflake User Role
Running Sync connection metadata; Sync now

Add Sigma IPs to the allowlist

In some cases, you may need to add Sigma's IP addresses to the allowlist, so you can successfully connect to your data. This is a necessary step when your warehouse is closed to external connections due to firewalls, security groups, or other IP-based security policies. 

Sigma' lists its egress IP addresses on all individual Connection page. To see them, follow these steps:

  1. Open the Administration > Connections page.
  2. Select the relevant connection. 
    If you don't have a connection to the data source, click Create Connection.
  3. In the Connection Credentials section, see the IPs listed under the Host field. 
PostgreSQL
Sigma must be authenticated either at the Network level, or through 
Client Authentication.
Redshift
See Amazon Redshift cluster security groups.
Snowflake
See Network Policies.

Permissions for the Snowflake user role

Sigma uses the Snowflake user role specified on the connection.

Unless you have the correct permission grants to the user in Snowflake, you cannot see the data in Sigma. Learn more about granting permission to a user role in Snowflake.

If the connection uses OAuth with Snowflake, it inherits the permissions for each member of the organization directly from Snowflake. To troubleshoot permissions for an individual user or a Service Account user, confirm that they:

  • Have access permissions on your Snowflake warehouse
  • Inherit the intended role through your OAuth Provider

Sync your data

Sigma automatically (and periodically) syncs your connection's metadata.

When you make changes in your cloud data warehouse, such as updating the schema for a table, you must perform a manual sync so these changes reflect in Sigma immediately.

You can sync the entire connection; or sync a specific database, schema, or table.

To make the manual sync, follow these steps:

  1. Navigate to Administration > Connections.
  2. Select the relevant connection from the list.
  3. Click Browse connection.
  4. To sync the entire connection, click the sync icon, , on the connection.
    Sync the entire connection
  5. To sync an individual database, expand the connection, find the database, and click the action icon, Action icon, next to the name of the database. Alternatively, you can find the database by name by searching for it.
    From the drop-down menu, select Sync now.
    Sync database
  6. To sync an individual table, expand the connection, find the database that contains the table, expand that database, find the table, and then click the action icon, Action icon, next to the name of the table. Alternatively, you can find the table by name by searching for it.
    From the drop-down menu, select Sync now.
    Sync table

 



Was this page helpful?
Yes No