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

Prerequisites

  • To view MaxCompute tenant tables, you must associate a MaxCompute compute engine instance with the current workspace. For more information, see Configure a workspace.
  • To view AnalyticDB for PostgreSQL tenant tables, you must associate an AnalyticDB for PostgreSQL compute engine instance with the current workspace and collect the metadata of the AnalyticDB for PostgreSQL instance on the DataMap page in the DataWorks console. For more information, see Configure a workspace and Collect metadata from an AnalyticDB for PostgreSQL data store.
  • To view Hologres tenant tables, you must associate a Hologres compute engine instance with the current workspace and collect the metadata of the Hologres instance on the DataMap page in the DataWorks console. For more information, see Configure a workspace.
  • To view E-MapReduce (EMR) tenant tables, you must associate an E-MapReduce compute engine instance with the current workspace and collect the metadata of the E-MapReduce instance on the DataMap page in the DataWorks console. For more information, see Configure a workspace and Collect metadata from an E-MapReduce data store.

Procedure

  1. Go to the DataStudio page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region where your workspace resides, find the workspace, and then click Data Analytics in the Actions column.
  2. In the left-side navigation pane, click Tenant Tables.
    Click the Show icon in the lower-left corner to show or hide the left-side navigation pane.
  3. Specify the type and name of the compute engine to view the tenant tables.
    MaxCompute
    The following table describes the parameters related to a MaxCompute instance.
    Parameter Description
    Project The name of the project in the related environment.
    You can click the Filter icon icon next to the project or table name search box and select an environment.
    Note
    • For a workspace in standard mode, tenant tables in both the development and production environments are displayed.

      For a workspace in basic mode, only tenant tables in the production environment are displayed.

    • The current environment is highlighted in blue.
    Table Name The name of the table in the related environment.
    Columns The information of fields in the current table, including the number of fields, field type, and field description.
    Partitions The information and 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.
    Notice The partition information is displayed only for MaxCompute tenant tables.
    Preview This parameter allows you to preview the data in the current table.
    Notice
    • Only the data of MaxCompute tenant tables can be previewed.
    • External tables do not support data preview.