Create a New Database Connection

  1. Click the profile icon on the top right-hand side of the screen, then select 'Settings'.
  2. Click the Connections tab
  3. Select + Add Connection.
  4. Select which type of database you would like to add, and enter the requested information.
    Connect to Snowflake
    Connect to BigQuery
    Connect to Redshift

A‍fter creating the connection, you can assign your users and teams permission to use the data in the database. 

Term Definition
Name The name of the connection that Sigma will display in the connection list
Host The host path where your database is located
Port The port Sigma will use to connect to the host
Username The username you use when connecting to the database
Database The name of the database you would like to query using Sigma
Billing Project ID Your BigQuery Project ID
Server The server we will use to connect to Snowflake 

 

In some cases, you may need to whitelist Sigma's IP address:

104.197.169.18

104.197.193.23

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us