Analyze data in your data warehouse, run interactive queries, and visualize results to support decision-making.
Prerequisites
You must activate the Intelligent R&D Edition.
Analysis platform
Run SQL code in Dev or Basic projects that you have permissions for. You can also bind a dedicated compute source to run SQL queries independently of any project. We recommend setting up a dedicated compute source before you begin. For more information, see compute source.
The analysis platform supports the following offline compute sources: MaxCompute, Hadoop, Transwarp TDH 6.x, AnalyticDB for PostgreSQL, ArgoDB, StarRocks, GaussDB (DWS), Amazon EMR, SelectDB, Doris, Lindorm (compute engine), and OushuDB. When you use GaussDB (DWS), Amazon EMR, SelectDB, Doris, or OushuDB as an offline compute source, manual tables are not supported.
After you create a compute source, you must bind it to the analysis platform. For more information, see Analysis platform settings.
-
Notebook: Create a notebook to document your analysis workflow, including code, execution results, and conclusions. For more information, see Create a notebook on the analysis platform.
-
SQL query: Create SQL queries to retrieve data and visualize the results for statistical analysis. For more information, see Create an SQL query on the analysis platform.
-
Manual table: Create and edit data tables directly in the production environment. For more information, see Create a manual table on the analysis platform.
-
My Data Tables: Click My Data Tables to view your data tables on the analysis platform. For more information, see View and manage tables on the analysis platform.
Supported data sources
-
MySQL
-
AnalyticDB for PostgreSQL
-
AnalyticDB for MySQL 2.0
-
AnalyticDB for MySQL 3.0
-
Oracle
-
Presto
-
PostgreSQL
-
StarRocks
-
ClickHouse
-
GaussDB (DWS)
-
Doris
-
SelectDB
-
Microsoft SQL Server
-
Hologres
-
openGauss
-
DM
-
OceanBase
-
Trino
-
PolarDB-X 2.0
-
Lindorm (excluding data sources whose connection type is wide-column engine-HBase)
-
OushuDB