Support

Supported regions, data platforms, and features

View as Markdown

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 KingdomLondoneu-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
EuropeNetherlandswesteurope (primary)
northeurope (disaster recovery)		api.eu.azure.sigmacomputing.com
CanadaTorontocanadacentral (primary)
canadaeast (disaster recovery)		api.ca.azure.sigmacomputing.com
United KingdomLondonuksouth (primary)
ukwest (disaster recovery)		api.uk.azure.sigmacomputing.com
Australia4New South Walesaustraliaeast (primary)
australiasoutheast (disaster recovery)		api.au.azure.sigmacomputing.com
Google Cloud logoUnited States1,3Iowaus-central-1api.sigmacomputing.com
Kingdom of Saudi Arabia1,2,3Dammamme-central2api.sa.gcp.sigmacomputing.com

1GCP-hosted organizations don’t support private connections.

2Sign ups and free trials are not available in the GCP KSA region. Contact Sigma sales for enablement in this region.

3These regions are not yet supported for customer-managed keys.

4Audit logging is not yet supported for the Azure Australia region.

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
  • Warehouse AI model integration
  • Geography data type
  • Referencing multi-select controls in custom SQL
  • The following Array functions: Array, ArrayCompact, ArrayDistinct, ArrayExcept, ArrayIntersection, ArrayJoin, ArraySlice, Sequence, SplitToArray
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope, SparklineAgg
  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within
  • The following Passthrough functions: AggGeography, CallGeography
  • Specifying primary keys in the connection explorer
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
  • Warehouse AI model integration
  • Geography data type
  • Hierarchy columns
  • Referencing multi-select controls in custom SQL
  • Copying input table data when tagging a version or swapping sources
  • The following Array functions: ArrayContains, ArrayCompact, ArrayDistinct, ArrayExcept, ArrayJoin, ArraySlice, RaggedHierarchy, Sequence, SplitToArray
  • The following Aggregate functions: ArrayAgg, ArrayAggDistinct, ArrayDistinct, ArrayIntersection, Corr, RegressionIntercept, RegressionR2, SparklineAgg 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
  • Warehouse AI model integration
  • Geography data type
  • Referencing multi-select controls in custom SQL
  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within
  • The following Array functions: Array, ArrayAggDistinct, ArrayCompact, ArrayConcat, ArrayTransform, ArrayFilter, Sequence, SplitToArray
  • The following Passthrough functions (including Call and Agg variations): Geography, Variant, Logical
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope
  • The following Date functions: DateParse, LastDay
  • The following Text functions: RegexpMatch, RegexpReplace, RegexpExtract, MD5, SHA256, SplitPart, Proper
  • The following Math functions: BinFixed
  • The following Window functions: CumulativeCorr, MovingCorr, Corr, Nth
  • Regex text matching in filters
  • Custom SQL containing CTE’s
  • Sample connections
  • Specifying primary keys in the connection explorer
ClickHouse

ClickHouse connections don’t support the following features:

  • Connection-level OAuth authentication
  • Private link connections and Secure Shell (SSH) protocol connections
  • Input table and write back functionality, including: CSV uploads, use of input tables, running Python code
  • Stored procedures
  • Dataset warehouse views
  • Export to cloud storage
  • Query ID cache
  • User attributes for role and warehouse switching
  • Sample connections
  • Column values with strings that are not in UTF-8 format
  • All Geography functions
  • All Array functions except for Array, ArrayContains, and ArrayLength
  • The following Passthrough functions: CallGeography, AggGeography
  • Materialization and warehouse views is only supported for ClickHouse Cloud instances and single-node self-hosted ClickHouse instances
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
  • The following Array functions: ArrayConcat, ArrayDistinct, ArrayExcept, ArraySlice
  • The following Geography functions: Centroid, Intersects, Within
  • SSH
  • 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
  • User attributes for role and warehouse switching
  • Running Python code
  • Referencing multi-select controls in custom SQL
  • Copying input table data when tagging a version or swapping sources
  • 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
  • Warehouse AI model integration
  • Geography data type
  • Referencing multi-select controls in custom SQL
  • The following Array functions: ArrayAgg, ArrayAggDistinct, ArrayCompact, ArrayDistinct, ArrayExcept, ArrayIntersection, ArrayJoin, Sequence, 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
  • Specifying primary keys in the connection explorer
PostgreSQL

PostgreSQL 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
  • Running Python code
  • Warehouse AI model integration
  • Geography data type
  • Copying input table data when tagging a version or swapping sources
  • Referencing multi-select controls in custom SQL
  • 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
  • Specifying primary keys in the connection explorer
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
  • Referencing multi-select controls in custom SQL
  • Warehouse AI model integration
  • The following Array functions: Array, ArrayCompact, ArrayConcat, ArrayDistinct, ArrayExcept, ArrayIntersection, ArraySlice
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope
  • The following Geography functions: Centroid, Within, Intersects, Perimeter
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
  • Warehouse AI model integration
  • Geography data type
  • Referencing multi-select controls in custom SQL
  • All Geography functions: Area, Centroid, Distance, Geography, Intersects, Json, Latitude, Longitude, MakeLine, MakePoint, Perimeter, Text, Within
  • The following Array functions: Array, ArrayAgg, ArrayAggDistinct, ArrayCompact, ArrayTransform, ArrayFilter, Sequence, SplitToArray
  • All Passthrough functions
  • The following Aggregate functions: RegressionIntercept, RegressionR2, RegressionSlope, SparklineAgg
  • The following Date functions: DateParse, LastDay
  • The following Text functions: RegexpMatch, RegexpReplace, RegexpExtract, MD5, SHA256, SplitPart, Proper
  • The following Math functions: BinFixed
  • The following Window functions: CumulativeCorr, MovingCorr, Corr, Nth
  • Regex text matching in filters
  • Custom SQL containing CTE’s
  • Sample connections
  • Specifying primary keys in the connection explorer

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: