View tenant tables-DataWorks(DataWorks)-阿里云帮助中心

DataWorks allows you to view MaxCompute, AnalyticDB for PostgreSQL, Hologres, and E-MapReduce (EMR) tables in the workspaces of a tenant. You can filter tenant tables by the type and name of the compute engine in the Tenant Tables pane.

Prerequisites

To view tenant tables for MaxCompute, AnalyticDB for PostgreSQL, Hologres, or E-MapReduce (EMR), you must bind the corresponding computing resource in DataStudio. For more information, see Prepare for data development: Bind a computing resource or a cluster.

Note

For AnalyticDB for PostgreSQL, Hologres, and E-MapReduce (EMR) data sources, you must also collect their metadata on the Data Map page. For more information, see Collect metadata.

Procedure

Go to the DataStudio page.

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 navigation pane on the left, click Tenant Tables.

You can click the icon in the lower-left corner to show or hide the pane names in the left-side navigation pane.

Specify the type and name of the compute engine to view the tenant tables.

The following table describes the parameters related to a MaxCompute compute engine.

Parameter	Description
Project	The name of the project in the related environment. You can click the icon next to the search box and select an environment. Note For a workspace in standard mode, tenant tables from both the Development Environment and Production Environment are displayed. For a workspace in basic mode, only tenant tables from the Production Environment are displayed. The current environment is highlighted in blue.
Table Name	The name of the table in the related environment.
Column	The information of fields in the current table, including the number, data types, and descriptions of the fields.
Partition Information	The information about and the number of partitions of the current table. A maximum of 60,000 partitions can be created. If you have specified the time to live (TTL) for partitions, the number of partitions depends on the TTL. By default, only 10 partitions are displayed. Important The partition information is displayed only for MaxCompute tenant tables. This view shows incomplete partition information. To view all partitions of a MaxCompute table, run the `show partitions <tablename>` command.
Preview Data	This parameter allows you to preview the data in the current table. Important Only the data of MaxCompute tenant tables can be previewed. External tables do not support data preview.