In the Workspace Tables pane of the DataStudio page in the DataWorks console, you can view tables based on the folders or the types of compute engines to which the tables belong. You can also search for a table by compute engine type, environment, or table name, and modify the information of the table on the configuration tab of the table. In addition, you can create a table and import data into the table. This topic describes the operations that can be performed on a table displayed in the Workspace Tables pane of the DataStudio page.
Prerequisites
- Required folders and layers are created. You can quickly locate a table based on the folder in which the table is stored and change the layer to which the table belongs. For more information, see Manage settings for tables.
Concept Description Folder Folders are used to store and manage tables in a workspace. You can create different folders based on dimensions such as the use scenarios and categories of tables. This way, you can store tables of the same type in the same folder for centralized management. Layer Layers are used to classify and store data that is used in different scenarios. This way, you can organize, manage, and maintain data in a more efficient manner. In addition, you can create categories to classify tables in a finer-grained manner based on your business requirements. - Required compute engines are associated with your workspace, and the metadata of the compute engines is collected. The metadata of compute engines can be used to quickly locate the desired tables. The following table lists the types of compute engines that can be associated with a workspace.
Compute engine type References MaxCompute Hologres E-MapReduce (EMR) AnalyticDB for PostgreSQL AnalyticDB for MySQL CDH
Go to the Workspace Tables pane
- Go to the DataStudio page.
- Log on to the DataWorks console. In the top navigation bar, select the region where your workspace resides. In the left-side navigation pane, click Workspaces.
- On the Workspaces page, find the workspace that you want to manage and click DataStudio in the Actions column to go to the DataStudio page.
- In the left-side navigation pane of the DataStudio page, click Workspace Tables.
Create, search for, or modify a table
- Create a table and import data into the table
In the Workspace Tables pane, you can click the
icon to create a table and click the 
icon to import data into the table. The following table lists the types of tables that you can create.
For information about how to import data into a table, see Import data to a MaxCompute table.Table type References MaxCompute Create a MaxCompute table AnalyticDB for PostgreSQL Create an AnalyticDB for PostgreSQL table E-MapReduce (EMR) Create an EMR table Hologres internal table Create a Hologres internal table Hologres external table Create a Hologres external table - Search for a table
In the Workspace Tables pane, you can use one of the following methods to view tables based on the following dimensions: View by Table Theme and View Metadata by Engine. You can search for a table by compute engine type, table name, or environment. You can also specify the order in which the system displays tables. This way, you can quickly find the desired table.Note
- Tables that are created in a workspace in standard mode exist in both the development environment and production environment. Tables that are created in a workspace in basic mode exist only in the production environment.
- By default, a maximum of 5,000 tables are displayed. We recommend that you use the search feature to find the desired table.
- Modify a table
You can find the name of the desired table and double-click the name to go to the configuration tab of the table. On the configuration tab, you can modify the information of the table. After you modify the information of the table, you must commit the table to the desired environment to make the modifications take effect. The following table lists the types of tables that you can modify.
Table type References MaxCompute Create a MaxCompute table AnalyticDB for PostgreSQL Create an AnalyticDB for PostgreSQL table E-MapReduce (EMR) Create an EMR table Hologres internal table Create a Hologres internal table Hologres external table Create a Hologres external table