Supported regions, data platforms, and features

Sigma supports various cloud platforms and regions, connections to many data platforms, and some features are supported only on specific data platforms.

Supported cloud platforms and regions

Your Sigma organization is hosted on one of the following cloud platforms:

  • Amazon Web Services (AWS)
  • Microsoft Azure
  • Google Cloud (GCP)

Your cloud deployment is chosen when your Sigma organization is created, and cannot be migrated or changed after creation.

💡

If you're unsure which cloud platform hosts your organization, you can reference it in the Administration portal (if you're assigned the Admin account type). Go to Administration > Account > General Settings, then locate the Site section. The Cloud field identifies the platform hosting your organization.

The following table lists the specific supported cloud regions:

Cloud platformRegionLocationCloud region codeAPI endpoint
AWS logoUnited States WestOregonus-west-2 (primary)
us-east-1 (disaster recovery)
aws-api.sigmacomputing.com
United States EastN. Virginiaus-east-1 (primary)
us-west-2 (disaster recovery)
api.us-a.aws.sigmacomputing.com
CanadaCentralca-central-1api.ca.aws.sigmacomputing.com
EuropeFrankfurteu-central-1 (primary)
eu-north-1 (disaster recovery)
api.eu.aws.sigmacomputing.com
Asia PacificSydneyap-southeast-2api.au.aws.sigmacomputing.com
United Kingdom1Londoneu-west-2 (primary)
eu-west-1 (disaster recovery)
api.uk.aws.sigmacomputing.com
Azure logoUnited StatesVirginiaeastus2 (primary)
centralus (disaster recovery)
api.us.azure.sigmacomputing.com
Europe2Netherlandswesteurope (primary)
northeurope (disaster recovery)
api.eu.azure.sigmacomputing.com
CanadaTorontocanadacentralapi.ca.azure.sigmacomputing.com
United Kingdom2Londonuksouthapi.uk.azure.sigmacomputing.com
Google Cloud logoUnited States3Iowaus-central-1api.sigmacomputing.com

1Sigma users of AWS-hosted organizations in the UK are not granted access to audit logs.

2Sigma users of Azure-hosted organizations in the EU and UK are not granted access to audit logs.

3GCP-hosted organizations don't support private connections.

Supported data platforms and feature compatibility

Sigma connects to the following data platforms:

  • AlloyDB
  • Azure SQL Database
  • Amazon Redshift
  • Databricks
  • Google BigQuery
  • MySQL
  • PostgreSQL
  • Snowflake
  • Starburst Galaxy
  • SQL Server 2022 and Azure SQL Managed Instance

Connections support most Sigma features; however, due to technical variations (like SQL dialects, architecture, and security) some features are not currently compatible with all data platforms. The following table lists current feature limitations for each connection type.

CDW/DBMSFeature limitations
AlloyDB

AlloyDB connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Input tables
  • Private link
  • Export to cloud storage
  • OAuth connections
  • Sigma result IDs cache
  • User attributes for role and warehouse switching
  • Running Python code
  • Geography data type
  • The following Array functions: Array, ArrayDistinct, ArrayExcept, ArrayIntersection, ArrayJoin, ArraySlice, SplitToArray

  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope

  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within

  • The following Passthrough functions: AggGeography, CallGeography

Amazon Redshift

Amazon Redshift connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Private link on GCP platform
  • OAuth connections
  • Sigma result IDs cache
  • User attributes for role and warehouse switching
  • Running Python code
  • Geography data type
  • The following Array functions: ArrayContains, ArrayDistinct, ArrayExcept, ArrayJoin, ArraySlice, Sequence, SplitToArray

  • The following Aggregate functions: ArrayAgg, ArrayDistinct, ArrayIntersection, Corr, RegressionIntercept, RegressionR2, RegressionSlope

  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within

  • The following Passthrough functions: AggGeography, CallGeography

  • The following Window functions: CumulativeCorr, MovingCorr

Azure
SQL

Azure SQL Database connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Export to cloud storage
  • OAuth connections
  • Sigma result IDs cache
  • User attributes for role and warehouse switching
  • Write-back features: CSV uploads, Input tables, running Python code
  • Geography data type
  • All Geography functions
  • The following Array functions: SplitToArray
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope

  • The following Passthrough functions (including Call and Agg variations): Geography, Variant, Logical

  • The following Window functions: CumulativeCorr, MovingCorr, Corr

  • Custom SQL containing CTE's
  • Sample connections

Databricks

Databricks connections don't support the following features:

  • Private link on GCP platform
  • Export to cloud storage
  • Sigma result IDs cache
  • User attributes for role and warehouse switching
  • Geography data type
  • The following Array functions: Array, ArrayAgg, ArrayDistinct, ArrayExcept, ArrayIntersection, ArraySlice

  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within

  • ML forecasting
  • SSH
  • The following Passthrough functions: AggGeography, CallGeography

  • Stored procedure actions
  • Multi-select columns for input tables
Google BigQuery

Google BigQuery connections don't support the following features:

  • Private link
  • Export to cloud storage
  • OAuth connections
  • User attributes for role and warehouse switching
  • Running Python code
  • The following Array functions: Sequence
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope

MySQL

MySQL connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Input tables
  • Private link on GCP platform
  • Export to cloud storage
  • OAuth connections
  • Sigma result IDs cache
  • User attributes for role and warehouse switching
  • Running Python code
  • Geography data type
  • The following Array functions: ArrayAgg, ArrayAggDistinct, ArrayDistinct, ArrayExcept, ArrayIntersection, ArrayJoin, SplitToArray

  • The following Aggregate functions: Corr, RegressionIntercept, RegressionR2, RegressionSlope

  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within

  • The following Passthrough functions: AggGeography, CallGeography

  • The following Window functions: CumulativeCorr, MovingCorr
PostgreSQL

PostgreSQL connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Input tables
  • Private link on GCP platform
  • Export to cloud storage
  • OAuth connections
  • Sigma result IDs cache
  • Running Python code
  • Geography data type
  • The following Array functions: Sequence
  • The following Text functions: SHA256
  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within

  • The following Passthrough functions: AggGeography, CallGeography

Snowflake

Snowflake connections don't support the following features:

  • Private link on GCP platform
  • The following Window functions: CumulativeCorr, MovingCorr
Starburst Galaxy

Starburst Galaxy connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Workbook warehouse views
  • Write-back features: Input tables, CSV upload, and Materialization

  • Private link
  • Export to cloud storage
  • OAuth connections
  • Sigma result IDs cache
  • User attributes for role and warehouse switching
  • Running Python code
  • The following Array functions: Array, ArrayDistinct, ArrayExcept, ArrayIntersection, ArraySlice

  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope

  • The following Geography functions: Centroid, Within, Intersects, Perimeter

  • The following Passthrough functions: AggGeography, CallGeography

SQL Server 2022 and Azure SQL Managed
Instance

SQL Server 2022 and Azure SQL Managed Instance connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Export to cloud storage
  • OAuth connections
  • Sigma result IDs cache
  • User attributes for role and warehouse switching
  • Write-back features: CSV uploads, input tables, running Python code
  • Geography data type
  • All Geography functions
  • The following Array functions: SplitToArray
  • All Passthrough functions
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope

  • The following Window functions: CumulativeCorr, MovingCorr, Median

  • Custom SQL containing CTE's
  • Sample connections

Supported web browsers

Sigma supports the following web browsers:

  • Google Chrome (recommended): latest version
  • Safari: latest version
  • Mozilla Firefox: latest version
  • Microsoft Edge: latest version
  • Opera: latest version

Supported authentication methods

Sigma supports the following authentication methods: