Create, Search, and Organize Tables in DataStudio - DataWorks - Alibaba Cloud - DataWorks

In DataWorks, the Workspace Tables module lets you manage tables by viewing them by Table Theme or compute engine. You can filter tables by compute engine, environment, and name for quick searching and editing, and you can also create new tables and import data.

Prerequisites

Define Table Themes and layers to help you quickly find tables by theme and modify their layers. For more information, see Define Table Themes and layers.

Concept	Description
Table Theme	A Table Theme helps organize and manage tables within a workspace. You can define custom themes based on usage, category, or other dimensions to group related tables.
layer	A layer classifies data for different purposes, which helps you better organize, manage, and maintain it. This concept also enables a more detailed, business-oriented classification of tables.

Add a data source, associate it with Data Development, and collect metadata from the relevant compute engine. This enables you to find tables by browsing compute engine metadata. For more information, see the following table.

Task	Reference
Add a data source	Associate a MaxCompute compute resource
	Associate a Hologres compute resource
	Associate an AnalyticDB for PostgreSQL compute resource
	Associate an AnalyticDB for MySQL V3.0 compute resource
	Associate a ClickHouse compute resource
	Data Development (Legacy): Associate an EMR compute resource
	Data Development (Legacy): Associate a CDH compute resource
Preparations	Preparations: Associate a compute resource or a cluster
Metadata collection	Metadata collection

Accessing table management

Go to Data Development.
1. Log on to the DataWorks console. In the target region, click Data Development and O&M > Data Development in the left-side navigation pane. Select a workspace from the drop-down list and click Go to Data Development.
In the left-side navigation pane, click Table Management.

Create, find, and edit tables

Create a table and import data

On the Workspace Tables page, you can click the icon to create a table and the icon to import data.

For more information about table configurations, see the following documentation.

Table type	Related documentation
MaxCompute	Create and use MaxCompute tables
AnalyticDB for PostgreSQL	Create an AnalyticDB for PostgreSQL table
E-MapReduce	Create an E-MapReduce table
Hologres internal table	Create a Hologres internal table
Hologres external table	Create a Hologres external table

To import data into a table, see Upload data.

Find a table
On the Workspace Tables page, you can view tables in two ways: View by Table Theme and View Metadata by Engine. DataWorks also lets you filter tables by compute engine, table name, and environment, and customize the display order for quick searching and viewing.
Note
- Only tables in standard mode workspaces distinguish between the Development environment and the Production environment. Tables in basic mode workspaces include only the Production environment.
- By default, a maximum of 5,000 data tables are displayed. Use the search feature to find a specific table.
- Currently, only MaxCompute and Hologres compute engines support displaying target tables by using the View Metadata by Engine option. Other compute engines, such as EMR, can only display tables by using the View by Table Theme option. The specific features supported by each compute engine are subject to the user interface.

Edit table

Double-click the target table to open the edit page. On this page, modify the table information as needed. Submit the changes to the appropriate environment for them to take effect. The following table provides details about table configurations.

Table type	Related documentation
MaxCompute	Create and use MaxCompute tables
AnalyticDB for PostgreSQL	Create an AnalyticDB for PostgreSQL table
E-MapReduce	Create an E-MapReduce table
Hologres internal table	Create a Hologres internal table
Hologres external table	Create a Hologres external table