You can import multiple tables from your on-premises machine to DataWorks Dimensional Modeling using an Excel file or export a table from DataWorks Dimensional Modeling to your on-premises data warehouse. This topic describes how to import tables to Dimensional Modeling and export a table from Dimensional Modeling.
Modeling by importing
This section describes how to import tables from your on-premises machine to Dimensional Modeling using an Excel file.
On the Dimensional Modeling page, click the
icon and select Import from Excel.On the Create Import Task page, select an Import Type and download the corresponding template. Fill in the template with the information for the models to import, and then import the data as prompted. For more information, see Import.
Export a table
This section describes how to export a table from Dimensional Modeling as an SQL file or as code.
Make sure that a dimension table, fact table, or aggregate table has been created. For more information, see Create a logical model: Dimension table, Create a logical model: Fact table, or Create a logical model: Aggregate table.
On the Dimensional Modeling page, double-click the table in the directory tree.
On the table details page on the right, click Export in the toolbar. You can select to export a Data Definition Language (DDL) statement for a MaxCompute, Hologres, or Hive engine, or a Data Manipulation Language (DML) statement for a MaxCompute engine.
In the DDL export dialog box that appears, the statement to create the table is displayed. Click Export File to generate an SQL file. You can also click Copy and run the command in the corresponding engine.
