Advanced feature support

Data source type

Data source

Supported features

Initialization SQL

Upload file

Custom week

HINT statement

Quick engine acceleration

Data preparation

Data entry

Complex data entry

Built-in functions

Trend/multidimensional analysis

Q-analysis exploration

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

✅

✅

Kingbase

Gbase 8a

✅

✅

Snowflake

Kylin

TiDB

✅

✅

✅

Dameng

✅

✅

✅

✅

✅

✅

Shentong Database

✅

✅

Greenplum

✅

✅

✅

✅

Alibaba Cloud data source

ApsaraDB RDS for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS MySQL 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

✅

E-MapReduce Serverless StarRocks

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Log Service (SLS)

✅

Elasticsearch

SelectDB

✅

✅

E-MapReduce Serverless Spark

✅

✅

✅

✅

✅

AWS data source

RDS for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS for PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

RDS for SQL Server

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Aurora MySQL

✅

✅

✅

✅

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

✅ (JDBC connection only)

✅

✅

✅

Data Management Service

✅

✅

Yida

✅

✅

Lark Base

✅

Lark Sheets

✅

DingTalk Sheets

✅

DingTalk AI Sheets

✅

Lingyang One Analytics

✅

✅