Create a new database connection
Contents
- Requirements
- Create a connection
- Adding Sigma IPs to the allowlist
- Write access
- Permissions
- Query timeouts
Requirements
- Admin privileges in your Sigma organization.
For more information, see User account types. - A data warehouse that Sigma supports.
These include Snowflake, BigQuery, Redshift, Databricks, PostgreSQL, AlloyDB, and MySQL
.
Create a connection to the data warehouse
Each warehouse type takes different input parameters. Use the following instructions for your warehouse:
- Connect to AlloyDB
- Connect to BigQuery
- Connect to Databricks
- Connect to MySQL
- Connect to PostgreSQL
- Connect to Redshift
- Connect to Snowflake
Adding Sigma IPs to the allowlist
When your warehouse is closed to external connections because of firewalls, security groups, or other IP-based security policies, you have to add Sigma's IP addresses to the allowlist, so you can successfully connect to your data.
Sigma's egress IP addresses are listed on all individual connection pages in your Sigma Admin Portal. To view them:
- Open your Admin Portal to the Connection page.
- Select any connection or click Create Connection.
- Look for the IP addresses listed under connection credentials.
Write access
You can enable write access on your connection. Write access is required for materialization, CSV uploads, and Dataset Warehouse Views.
Permissions
After creating a connection, you can selectively share access with other people in your organization. For more information, see Data 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.