All data sources supported by Quick BI support the core analytics workflow, which includes dataset modeling, dashboards, spreadsheets, large-screen displays, ad hoc analysis, and self-service queries. The table below lists the advanced features supported by different data sources.
✅ indicates support; a blank indicates no support.
Data source type | Data source | Supported features | |||||||||
Initialization SQL | Upload file | Custom week | HINT statement | Quick Engine extraction acceleration | Data preparation | Data entry | Complex table entry | Built-in functions | Trend/multidimensional analysis | ||
Self-hosted data source | MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
MariaDB | ✅ | ✅ | ✅ | ||||||||
Oracle | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
ClickHouse | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||
Presto | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Hive | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Impala (not supported on EMR) | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
Spark SQL | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
HBase | |||||||||||
MongoDB | ✅ | ✅ | ✅ | ||||||||
Apache Doris | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
StarRocks | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
SelectDB | ✅ | ✅ | ✅ | ||||||||
Elasticsearch | ✅ | ||||||||||
SAP HANA | ✅ | ✅ | |||||||||
SAP IQ (Sybase IQ) | ✅ | ||||||||||
IBM DB2 LUW | ✅ | ||||||||||
Vertica | ✅ | ✅ | |||||||||
Kingbase | |||||||||||
Gbase 8a | ✅ | ✅ | |||||||||
Snowflake | |||||||||||
Kylin | |||||||||||
TiDB | ✅ | ✅ | ✅ | ||||||||
Dameng | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |||||
OSCAR | ✅ | ✅ | |||||||||
Greenplum | ✅ | ✅ | ✅ | ✅ | |||||||
Alibaba Cloud data source | RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
RDS for MySQL DuckDB | ✅ | ✅ (Not supported for read-only instances) | ✅ (Not supported for read-only instances) | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ||
RDS for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
RDS for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
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 | ✅ | ||||||||||
E-MapReduce Serverless StarRocks | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Log Service | ✅ | ||||||||||
Elasticsearch | |||||||||||
SelectDB | ✅ | ✅ | |||||||||
E-MapReduce Serverless Spark | ✅ | ✅ | ✅ | ✅ | ✅ | ||||||
AWS data source | RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
RDS for PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
RDS for SQLServer | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
Aurora MySQL | ✅ | ✅ | ✅ | ✅ | |||||||
Aurora PostgreSQL | ✅ | ✅ | ✅ | ✅ | |||||||
Redshift | ✅ | ||||||||||
Databricks | ✅ | ✅ | ✅ | ✅ | |||||||
Amazon Athena | ✅ | ✅ | |||||||||
Huawei Cloud data source | RDS for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
PostgreSQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
RDS for SQL Server | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | |
GaussDB | |||||||||||
GaussDB(DWS) | ✅ | ||||||||||
Tencent Cloud data source | TencentDB for MySQL | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
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 | (JDBC connections only) | ✅ | ✅ | ✅ | ||||||
DMS | ✅ | ✅ | |||||||||