> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://help.sigmacomputing.com/docs/connect-to-data-sources/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server. # Connect to data sources > A data source connection enables Sigma to communicate with your data platform and perform live data queries. A data source connection enables Sigma to communicate with your data warehouse. An open and available connection is necessary for Sigma to send commands and receive answers in the form of data result sets. To connect to a data source, every application (including Sigma) must provide a connection string that consists of the address or location of the data, appropriate user validations (user id and password), specific database configuration options, security options, and many more. Data source connections are expensive to create, relative to the time of operations that you can subsequently perform on them. Therefore, we open a connection and keep it active to perform a series of discrete operations. We manage the "closing" and refreshing of the connections regularly, so when you work with Sigma the next day, you can continue with your work and use the same connection, seamlessly. While connections are a very powerful tool, consider carefully before creating multiple connections to the same database entity. Because you cannot move data across connections, you cannot perform cross-table calculations. For example, if you access Table1 from Connection1 and Table2 from Connection2, you cannot look at these tables as a collective entity, even if they are in the same database. ## Requirements * You must be assigned the Admin [account type](/docs/create-and-manage-account-types) or an account type with the **Manage connections** feature permission enabled. * A data warehouse that Sigma supports. These include [Snowflake](/docs/connect-to-snowflake), [BigQuery](/docs/connect-to-bigquery), [Redshift](/docs/connect-to-redshift), [Databricks](/docs/connect-to-databricks), [PostgreSQL](/docs/connect-to-postgresql), [AlloyDB](/docs/connect-to-alloydb), and [MySQL](/docs/connect-to-mysql). ## Create a connection to the data warehouse Each warehouse type takes different input parameters. Use the following instructions for your connection method: * [Connect to AlloyDB](/docs/connect-to-alloydb) * [Connect to Azure SQL Database](/docs/connect-to-azure-sql-database) * [Connect to BigQuery](/docs/connect-to-bigquery) * [Connect to Databricks](/docs/connect-to-databricks) * [Connect to MySQL](/docs/connect-to-mysql) * [Connect to PostgreSQL](/docs/connect-to-postgresql) * [Connect to Redshift](/docs/connect-to-redshift) * [Connect to Snowflake](/docs/connect-to-snowflake) * [Connect to Starburst](/docs/connect-to-starburst) * [Connect to SQL Server 2022 and Azure SQL Managed Instance](/docs/connect-to-sql-server-2022) ## Add 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 Administration portal. To view them: 1. Open your Administration portal, then click **Connections** in the left navigation. 2. Select any connection or click **Create Connection**. 3. Look for the IP addresses listed under connection credentials. ![The Connection Credentials section of a Snowflake connection named snowflake-test, with the Host value followed by the list of IP addresses Sigma connects from.](/_fern-img/a41e1cf1e2005ace5cd2001521e562b86372780d6b635fe6cfcecda158a68527.webp) > **Info** > > The IP addresses listed on the connections summary are not applicable to connections over Private Link. If you need the IP addresses for a Private Link connection, [contact Sigma Support](/docs/submit-a-support-request). ## Write access You can [enable write access](/docs/set-up-write-access) on your connection. Write access is required for [materialization](/docs/materialization), [CSV uploads](/docs/upload-csv-data), [input tables](/docs/intro-to-input-tables), and [warehouse views](/docs/create-and-manage-workbook-warehouse-views). ## Permissions After creating a connection, you can selectively share access with other people in your organization. For more information, see [Data Permissions](/docs/data-permissions-overview). ## 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. ## Related resources * [Connect to AlloyDB](/docs/connect-to-alloydb) * [Connect to BigQuery](/docs/connect-to-bigquery) * [Connect to Databricks](/docs/connect-to-databricks) * [Connect to MySQL](/docs/connect-to-mysql) * [Connect to PostgreSQL](/docs/connect-to-postgresql) * [Connect to Redshift](/docs/connect-to-redshift) * [Connect to Snowflake](/docs/connect-to-snowflake) * [Connect to Starburst](/docs/connect-to-starburst) * [Connect to Azure SQL Database](/docs/connect-to-azure-sql-database) * [Connect to SQL Server 2022 and Azure SQL Managed Instance](/docs/connect-to-sql-server-2022) > Official documentation and guidance for using Sigma to build AI apps, dashboards, and agents on governed warehouse data. ## Docs - [Connect to Snowflake](https://help.sigmacomputing.com/docs/connect-to-snowflake.md): Sigma supports secure connections to Snowflake. - [Connect to Snowflake with OAuth](https://help.sigmacomputing.com/docs/connect-to-snowflake-oauth.md): Authenticate from Sigma to Snowflake with OAuth to allow users to inherit access policies from Snowflake. - [Set up a Snowflake connection for Python](https://help.sigmacomputing.com/docs/set-up-a-snowflake-connection-for-python.md): Set up Python on your Snowflake connection in Sigma to run notebook-style code for complex analysis and data science workflows. - [Specify query variables for a Snowflake connection (Beta)](https://help.sigmacomputing.com/docs/specify-query-variables-for-a-snowflake-connection.md): Set query variables on a Sigma connection to Snowflake to apply per-query SQL variables and enforce row-level security with Cortex Agents, including row access policy examples. - [Restore input table access for a Snowflake connection or user](https://help.sigmacomputing.com/docs/restore-input-table-access-for-a-snowflake-connection-or-user.md): Fix Snowflake input table access in Sigma when role or OAuth changes block creating tables or saving edits. - [Connect to Databricks](https://help.sigmacomputing.com/docs/connect-to-databricks.md): Connect to Databricks in Sigma. Configure SQL warehouses, credentials, and secure connections so users in your organization can analyze Databricks data. - [Connect to Databricks with OAuth](https://help.sigmacomputing.com/docs/connect-to-databricks-oauth.md): Connect Databricks to Sigma with OAuth. Use organization-level or connection-level OAuth configs so users authenticate with inherited permissions. - [Set up a Databricks connection for Python](https://help.sigmacomputing.com/docs/set-up-a-databricks-connection-for-python.md): Enable Python on your Databricks connection in Sigma to write and run notebook-style code for advanced analytics and data science. - [Connect to Redshift](https://help.sigmacomputing.com/docs/connect-to-redshift.md): Sigma supports secure connections to Amazon Redshift. - [Connect to BigQuery](https://help.sigmacomputing.com/docs/connect-to-bigquery.md): Connect to BigQuery in Sigma. Create a service account, configure credentials, and set up secure warehouse connections for your organization. - [Connect to BigQuery with OAuth (Beta)](https://help.sigmacomputing.com/docs/connect-to-bigquery-oauth.md): Connect to BigQuery with OAuth in Sigma. Set up connection-level OAuth so users inherit BigQuery permissions per account. - [Connect to AlloyDB](https://help.sigmacomputing.com/docs/connect-to-alloydb.md): Connect to AlloyDB in Sigma. Set up secure database connections so your organization can query AlloyDB data in workbooks and analyses. - [Connect to MySQL](https://help.sigmacomputing.com/docs/connect-to-mysql.md): Sigma supports secure connections to MySQL (release 8.x and higher). - [Connect to PostgreSQL](https://help.sigmacomputing.com/docs/connect-to-postgresql.md): Sigma supports secure connections to PostgreSQL. - [Connect to Starburst](https://help.sigmacomputing.com/docs/connect-to-starburst.md): Sigma supports using Starburst Galaxy, a SaaS distribution of Trino, to connect to a Snowflake, Databricks, BigQuery, or PostgreSQL data warehouse. - [Connect to Azure SQL Database](https://help.sigmacomputing.com/docs/connect-to-azure-sql-database.md): Connect Sigma to Azure SQL Database, a managed PaaS engine. Configure secure connections and verify supported instance types. - [Connect to SQL Server 2022 and Azure SQL Managed Instance](https://help.sigmacomputing.com/docs/connect-to-sql-server-2022.md): Connect Sigma to your SQL Server 2022 or Azure SQL Managed Instance data. - [Connect to ClickHouse (Beta)](https://help.sigmacomputing.com/docs/connect-to-clickhouse.md): Connect to ClickHouse in Sigma. Set up secure server connections and review supported features, requirements, and limitations.