Available in...
Big Data Platform
Cloud API Services Platform
Cloud Big Data Platform
Cloud Data Fabric
Cloud Data Management Platform
Data Fabric
Data Management Platform
Data Services Platform
MDM Platform
Real-Time Big Data Platform
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 |
|
| MySQL Restriction: From Talend Studio 8.0 R2023-07, MySQL InnoDB cluster is supported as a data mart. NDB
cluster is not supported.
|
|
|
|
| PostgreSQL |
Note: 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