Supported regions, data platforms, and features

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)

πŸ’‘

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.

Cloud platform Location Supported region API endpoint
AWS logo United States us-west-2 (primary)
us-east-1 (disaster recovery)
aws-api.sigmacomputing.com/v2
Canada ca-central-1 api.ca.aws.sigmacomputing.com
Europe1 eu-central-1
eu-north-1 (disaster recovery)
api.eu.aws.sigmacomputing.com
Australia and APAC1 ap-southeast-2 api.au.aws.sigmacomputing.com
United Kingdom1 eu-west-2
eu-west-1 (disaster recovery)
api.uk.aws.sigmacomputing.com
Azure logo United States East US 2 (primary)
South Central US (disaster recovery)
api.us.azure.sigmacomputing.com
Google Cloud logo United States2 us-central-1 (primary) api.sigmacomputing.com/v2

1 Due to GDPR and privacy requirements, Sigma users of AWS-hosted organizations in Europe, Australia, and APAC are not granted access to audit logs.

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

Supported data platforms and feature compatibility

Sigma connects to the following data platforms:

  • AlloyDB
  • Amazon Redshift
  • Databricks
  • Google BigQuery
  • MySQL
  • PostgreSQL
  • Snowflake

Every connection supports 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 logo

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
  • Geography data type
  • The following Array functions: Array, ArrayDistinct, ArrayJoin, ArraySlice, Sequence
  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within
  • The following Passthrough functions: AggGeography, CallGeography
Amazon Redshift logo

Amazon Redshift connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Input tables
  • Private link on GCP platform
  • Export to cloud storage
  • Sigma result IDs cache
  • Native JSON data types
  • Geography data type
  • The following Array functions: ArrayDistinct, ArrayJoin, ArraySlice, Sequence
  • The following Aggregate functions: ArrayAgg, ArrayDistinct, Corr
  • 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
Databricks logo

Databricks connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Private link on GCP platform
  • Export to cloud storage
  • OAuth connections
  • Sigma result IDs cache
  • Geography data type
  • The following Array functions: Array, ArrayDistinct, ArraySlice
  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within
  • The following Passthrough functions: AggGeography, CallGeography
Google Big Query logo

Google BigQuery connections don't support the following features:

  • Input tables
  • Private link
  • Export to cloud storage
  • OAuth connections
  • The following Array functions: Sequence
MySQL logo

MySQL connections don't support the following features:

  • Input tables
  • Private link
  • OAuth connections
  • Sigma result IDs cache
  • Geography data type
  • The following Array functions: ArrayAgg, ArrayAggDistinct, ArrayDistinct, ArrayJoin, Sequence
  • The following Aggregate functions: Corr
  • 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 logo

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
  • Geography data type
  • The following Array functions: ArrayDistinct, ArrayJoin, ArraySlice, Sequence
  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within
  • The following Passthrough functions: AggGeography, CallGeography
Snowflake logo

Snowflake connections don't support the following features:

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

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: