All Quick BI data sources support the core data analysis workflow, including dataset modeling, dashboards, spreadsheets, data dashboards, ad hoc analysis, self-service data retrieval, and intelligent features such as Q&A, reports, and interpretations. The following table lists which advanced features each data source supports.
✅ indicates support; a blank cell indicates no support.
|
Data source type |
Data source |
Supported features |
|||||||||
|
Initialization SQL |
Upload file |
Custom week |
Hint statement |
Quick engine acceleration |
Data preparation |
Data entry |
Complex table entry |
Built-in function |
Trend / dimensional analysis |
||
|
Self-hosted data source |
MySQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
PostgreSQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
SQL Server |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
MariaDB |
✅ |
✅ |
✅ |
||||||||
|
Oracle |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
ClickHouse |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|||
|
Presto |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|||||
|
Hive |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|||||
|
Impala (EMR not supported) |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|||||
|
Spark SQL |
✅ |
✅ |
✅ |
✅ |
✅ |
||||||
|
HBase |
|||||||||||
|
MongoDB |
✅ |
✅ |
✅ |
||||||||
|
Apache Doris |
✅ |
✅ |
✅ |
✅ |
✅ |
||||||
|
StarRocks |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
SelectDB |
✅ |
✅ |
✅ |
||||||||
|
Elasticsearch |
✅ |
||||||||||
|
SAP HANA |
✅ |
✅ |
|||||||||
|
SAP IQ (Sybase IQ) |
✅ |
||||||||||
|
IBM Db2 LUW |
✅ |
||||||||||
|
Vertica |
✅ |
✅ |
|||||||||
|
KingbaseES |
|||||||||||
|
GBase 8a |
✅ |
✅ |
|||||||||
|
Snowflake |
|||||||||||
|
Apache Kylin |
|||||||||||
|
TiDB |
✅ |
✅ |
✅ |
||||||||
|
DM |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|||||
|
OSCAR |
✅ |
✅ |
|||||||||
|
Greenplum |
✅ |
✅ |
✅ |
✅ |
|||||||
|
Alibaba Cloud data source |
ApsaraDB RDS for MySQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
ApsaraDB RDS for MySQL with DuckDB |
✅ |
✅ (Not supported on read-only instances) |
✅ (Not supported on read-only instances) |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
||
|
ApsaraDB RDS for PostgreSQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
ApsaraDB RDS for SQL Server |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
ApsaraDB RDS for MariaDB |
✅ |
✅ |
✅ |
||||||||
|
MaxCompute |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|||
|
Hologres |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
ClickHouse |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|||
|
AnalyticDB for MySQL 2.0 |
✅ |
✅ |
|||||||||
|
AnalyticDB for MySQL 3.0 |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
||
|
AnalyticDB for PostgreSQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
||||
|
PolarDB for MySQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
PolarDB for PostgreSQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
||||
|
PolarDB for PostgreSQL (Oracle Compatible) |
✅ |
✅ |
✅ |
✅ |
✅ |
||||||
|
PolarDB-X |
✅ |
✅ |
✅ |
✅ |
|||||||
|
Lindorm |
✅ |
||||||||||
|
OceanBase |
✅ |
||||||||||
|
Alibaba Cloud EMR Serverless StarRocks |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
Log Service |
✅ |
||||||||||
|
Elasticsearch |
|||||||||||
|
SelectDB |
✅ |
✅ |
|||||||||
|
Alibaba Cloud EMR Serverless Spark |
✅ |
✅ |
✅ |
✅ |
✅ |
||||||
|
AWS data source |
Amazon RDS for MySQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
Amazon RDS for PostgreSQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
Amazon RDS for SQL Server |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
Amazon Aurora MySQL |
✅ |
✅ |
✅ |
✅ |
|||||||
|
Amazon Aurora PostgreSQL |
✅ |
✅ |
✅ |
✅ |
|||||||
|
Amazon Redshift |
✅ |
||||||||||
|
Databricks |
✅ |
✅ |
✅ |
✅ |
|||||||
|
Amazon Athena |
✅ |
✅ |
|||||||||
|
HUAWEI CLOUD data source |
RDS for MySQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
RDS for PostgreSQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
RDS for SQL Server |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
GaussDB |
|||||||||||
|
GaussDB(DWS) |
✅ |
||||||||||
|
Tencent Cloud data source |
TencentDB for MySQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
TencentDB for PostgreSQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
TencentDB for SQL Server |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
TDSQL-H LibraDB |
✅ |
||||||||||
|
Microsoft Azure data source |
Azure Database for MySQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
Azure Database for PostgreSQL |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
Azure SQL Database |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
✅ |
|
|
Databricks |
✅ |
✅ |
✅ |
✅ |
|||||||
|
Application data source |
Dataphin |
✅ (with JDBC connections) |
✅ |
✅ |
✅ |
||||||
|
Data Management Service |
✅ |
✅ |
|||||||||