Advanced features for data sources

Data source type

Data source

Supported features

Initialization SQL

File upload

Custom week

HINT statement

Quick Engine acceleration

Data preparation

Data entry

Complex table entry

Built-in functions

Trend/crosstab

Q-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

✅

✅

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

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

ApsaraDB for 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)

✅

Alibaba Cloud 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

✅

Azure data source

Azure Database for MySQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Azure Database for PostgreSQL

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Azure SQL Database

✅

✅

✅

✅

✅

✅

✅

✅

✅

✅

Databricks

✅

✅

✅

✅

Application data source

Dataphin

✅ (For JDBC connections)

✅

✅

✅

Data Management (DMS)

✅

✅

Yida

✅

✅

Lark Bitable

✅

Lark Sheets

✅

DingTalk Sheets

✅

DingTalk AI Sheets

✅

Lingyang One Analytics

✅

✅