Troubleshoot your connection

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. See how to grant 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 at the connection, database, schema, or table level. Note that syncing only occurs at the level selected, and does not cascade to the levels below.

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 connection, which will discover updates to the databases available on that connection, click the sync icon, , on the connection.
    Sync the entire connection
  5. To sync an individual database or schema, expand the connection, find the container, and click the action icon, Action icon, next to the name of the database or schema. Alternatively, you can find the database or schema 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