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 platform Location Supported region API endpoint
AWS logo United States West us-west-2 (primary)
us-east-1 (disaster recovery)
aws-api.sigmacomputing.com
United States East us-east-1 (primary)
us-west-2 (disaster recovery)
api.us-a.aws.sigmacomputing.com
Canada ca-central-1 api.ca.aws.sigmacomputing.com
Europe eu-central-1 (primary)
eu-north-1 (disaster recovery)
api.eu.aws.sigmacomputing.com
Australia and APAC ap-southeast-2 api.au.aws.sigmacomputing.com
United Kingdom1 eu-west-2 (primary)
eu-west-1 (disaster recovery)
api.uk.aws.sigmacomputing.com
Azure logo United States eastus2 (primary)
centralus (disaster recovery)
api.us.azure.sigmacomputing.com
Europe2 westeurope (primary)
northeurope (disaster recovery)
api.eu.azure.sigmacomputing.com
Canada2 canadacentral api.ca.azure.sigmacomputing.com
Google Cloud logo United States3 us-central-1 api.sigmacomputing.com

1 Sigma 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 Canada are not granted access to audit logs.

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

Supported data platforms and feature compatibility

Sigma connects to the following data platforms:

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

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 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, ArrayExcept, ArrayIntersection, ArrayJoin, ArraySlice
  • 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 logo

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
  • Geography data type
  • The following Array functions: ArrayContains, ArrayDistinct, ArrayExcept, ArrayJoin, ArraySlice, Sequence
  • 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 logo

Azure SQL connections don't support the following features:

  • Dataset warehouse views created in Sigma
  • Workbook warehouse views
  • Export to cloud storage
  • OAuth connections
  • Sigma result IDs cache
  • User attributes for role and warehouse switching
  • Write-back features: CSV uploads, Input tables
  • Geography data type
  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within
  • 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
Google Big Query logo

Databricks connections don't support the following features:

  • Private link on GCP platform
  • Export to cloud storage
  • Sigma result IDs cache
  • 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 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
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope
  • MySQL logo

    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
    • Geography data type
    • The following Array functions: ArrayAgg, ArrayAggDistinct, ArrayDistinct, ArrayExcept, ArrayIntersection, ArrayJoin
    • 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 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
    • User attributes for role and warehouse switching
    • 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 logo

    Snowflake connections don't support the following features:

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

    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
    • 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 Logo

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

    • Dataset warehouse views created in Sigma
    • Workbook warehouse views
    • Export to cloud storage
    • OAuth connections
    • Sigma result IDs cache
    • User attributes for role and warehouse switching
    • Write-back features: CSV uploads and input tables
    • Geography data type
    • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within
    • 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: