Visual modeling provides external output capabilities, supporting the return of offline tables generated by intelligent data insights to the native system for secondary data production and mining, enabling more flexible data output and application. Currently supported external storage: MaxCompute, OceanBase Oracle, Mysql, LAS (public cloud), Transwarp Inceptor, Oracle, BytehouseCE.

This feature is a value-added function for the private deployment version and requires a paid purchase. If you have any requirements, please contact your account manager. After purchase, users must have Project Center - Data Preparation - Visual Modeling - Create Task permissions, and the customer side must allow table creation and data writing.

3.1 Operation process #

3.2 Currently supported external storage #

3.3 Operation steps #

(1) Click Data Preparation > Data Connection.

(2) In the upper left corner of the data connection directory, click the Create Data Connection button. Using MaxCompute as an example, select the Data Warehouse - MaxCompute data connection.

(3) On the edit page, fill in the corresponding server and key information, enable Write permission in the permission mode, and after successfully testing the connection, click Save.

(4) Click Visual Modeling - Create Task;

(5) On the task edit page, you can freely perform data cleaning and processing. After completion, add the External Output operator;
(6) In version V2.62.0, the process for creating and viewing tables has been simplified. It now supports displaying relevant content directly in the operation bar, improving your operational efficiency.

• Create a new output table and fill in the relevant information.
  
• View the output table directly in the operation bar; preview the table structure as well.