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 Region Location Cloud region code API endpoint
AWS logo United States West Oregon us-west-2 (primary)
us-east-1 (disaster recovery)
aws-api.sigmacomputing.com
United States East N. Virginia us-east-1 (primary)
us-west-2 (disaster recovery)
api.us-a.aws.sigmacomputing.com
Canada Central ca-central-1 api.ca.aws.sigmacomputing.com
Europe Frankfurt eu-central-1 (primary)
eu-north-1 (disaster recovery)
api.eu.aws.sigmacomputing.com
Asia Pacific Sydney ap-southeast-2 api.au.aws.sigmacomputing.com
United Kingdom1 London eu-west-2 (primary)
eu-west-1 (disaster recovery)
api.uk.aws.sigmacomputing.com
Azure logo United States Virginia eastus2 (primary)
centralus (disaster recovery)
api.us.azure.sigmacomputing.com
Europe2 Netherlands westeurope (primary)
northeurope (disaster recovery)
api.eu.azure.sigmacomputing.com
Canada2 Toronto canadacentral api.ca.azure.sigmacomputing.com
United Kingdom2 London uksouth api.uk.azure.sigmacomputing.com
Google Cloud logo United States3 Iowa 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, Canada, and UK 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
  • 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 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
  • 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 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
  • 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 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
  • 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 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 connections don't support the following features:

  • Input tables
  • Private link
  • Export to cloud storage
  • OAuth connections
  • User attributes for role and warehouse switching
  • The following Array functions: Sequence
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope
  • 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
    • 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 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: 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 connections don't support the following features:

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

    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
    • 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 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 and input tables
    • 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: