Create a New Database Connection

Create a Connection

  1. Open your Admin Portal by selecting ‘Administration’ in the user menu at the top right of your screen.
    Screen_Shot_2020-05-13_at_1.42.36_PM.png
  2. Select the ‘Connections’ page from the left hand panel.
  3. Click the ‘Create Connection’ button.
    Screen_Shot_2020-05-13_at_3.54.08_PM.png
  4. Name your connection.
  5. Select your warehouse type.
    Screen_Shot_2020-05-13_at_3.55.20_PM.png
  6. Each warehouse type requires different input. Use the following instructions for your warehouse:
    - Connect to Snowflake
    - Connect to BigQuery
    - Connect to Redshift or Postgres
  7. [optional] Under 'Connection Features’, you can set a connection timeout and/or enable write access.
  8. After completing the form, click the ‘Create’ button in the top right of your screen. 

Connection Credential Terms

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 

 
Whitelisting IPs

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

104.197.169.18
104.197.193.23

 

Write Access

You may want to enable write access on your connection. Write access is required for materialization, CSV uploads, and Dataset Warehouse Views.

Permissions

After creating a connection, you will likely want to selectively share access with other people in your organization. Learn more about permissions.

Query Timeouts

By default, Sigma sets query timeouts to 120 seconds (2 minutes). When queries hit the timeout limit, Sigma will cancel the query. Under 'Connection Features', you can set a custom query timeout for your connection.