Skip to main content Skip to complementary content

Supported databases for the data mart

The supported databases for the data mart might be different than the supported databases for profiling data.

The following table describes the supported databases for the data mart.
Database name Database version
HSQL Not applicable
Microsoft SQL Server
  • Google Cloud SQL for SQL Server
  • Amazon RDS for SQL Server
  • Azure SQL Database
  • 2017
  • 2016
  • 2014
  • 2012
MySQL
Information noteRestriction: MySQL InnoDB cluster is supported as a data mart. NDB cluster is not supported.
  • Google Cloud SQL for MySQL
  • Amazon RDS for Aurora
  • Amazon RDS for MySQL
  • Azure Database for MySQL
  • MySQL 8
  • MySQL 5
  • Oracle with SID
  • Oracle with service name
  • Oracle OCI
  • 18
  • Availability-noteDeprecated
    11, 12
PostgreSQL
  • Google Cloud SQL for PostgreSQL
  • Amazon RDS for PostgreSQL
  • Azure Database for PostgreSQL
  • 12 and later
Snowflake Not applicable

Running reports on Snowflake

The following lists the Snowflake privileges you need to run reports when the data mart is on Snowflake:
GRANT USAGE on WAREHOUSE <WAREHOUSE_NAME> to <ROLE_NAME>

GRANT USAGE on DATABASE <DB_NAME> to <ROLE_NAME>

GRANT USAGE on ALL SCHEMAS IN DATABASE <DB_NAME> to <ROLE_NAME>

GRANT SELECT, INSERT, UPDATE on ALL TABLES in DATABASE <DB_NAME> to <ROLE_NAME>

GRANT SELECT, INSERT, UPDATE on ALL VIEWS in DATABASE <DB_NAME> to <ROLE_NAME>

GRANT USAGE on ALL SEQUENCES in DATABASE <DB_NAME> to <ROLE_NAME>

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!