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: From Talend Studio 8.0 R2023-07, 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 11, 12 (deprecated from 8.0.1 R2023-01 onwards) 8, 9, 10 (removed from 8.0.1 R2023-01 onwards)
PostgreSQL	Google Cloud SQL for PostgreSQL Amazon RDS for PostgreSQL Azure Database for PostgreSQL 12 and later 9, 10, and 11 Information noteNote: From Talend Studio 8.0. R2024-03 onwards, only the PostgreSQL versions 12 and later are supported. The earlier versions have been removed.
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> WITH GRANT OPTION

GRANT USAGE on DATABASE <DB_NAME> to <ROLE_NAME> WITH GRANT OPTION

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

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

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

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

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 – let us know how we can improve!

Leave your feedback here