All Products
Search
Document Center

DataWorks:View tenant tables

Last Updated:Aug 14, 2023

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 with the current workspace. For more information, see Create and manage workspaces.
  • To view AnalyticDB for PostgreSQL tenant tables, you must associate an AnalyticDB for PostgreSQL compute engine 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 Create and manage workspaces and Collect metadata from an AnalyticDB for PostgreSQL data source.
  • To view Hologres tenant tables, you must associate a Hologres compute engine with the current workspace and collect the metadata of the Hologres instance on the DataMap page in the DataWorks console. For more information, see Create and manage workspaces.
  • To view E-MapReduce (EMR) tenant tables, you must associate an E-MapReduce compute engine 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 Create and manage workspaces and Collect metadata from an EMR data source.

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 the workspace resides. On the Workspaces page, find the workspace in which you want to create tables, and click Shortcuts > Data Development 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.
    ParameterDescription
    ProjectThe name of the project in the related environment.
    You can click the Filter 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 NameThe name of the table in the related environment.
    ColumnsThe information of fields in the current table, including the number of fields, field type, and field description.
    PartitionsThe 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.
    • The displayed partition information is incomplete. To view the complete partition information about a MaxCompute tenant table, run the show partitions <tablename> command.
    PreviewThis 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.