All Products
Search

This Product

    :View tenant tables

    Document Center

    :View tenant tables

    Last Updated:Nov 13, 2024

    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

    A MaxCompute, AnalyticDB for PostgreSQL, Hologres, or E-MapReduce data source is associated with DataStudio to view tenant tables of MaxCompute, AnalyticDB for PostgreSQL, Hologres, or E-MapReduce (EMR). For more information, see Preparations before data development: Associate a data source or a cluster with DataStudio.

    Note

    The metadata of an AnalyticDB for PostgreSQL, Hologres, or EMR instance is collected on the DataMap page in the DataWorks console to view AnalyticDB for PostgreSQL, Hologres, or EMR tenant tables. For more information, see Metadata collection.

    Procedure

    1. Go to the DataStudio page.

      Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose Data Development and Governance > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.

    2. In the left-side navigation pane, 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.

    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 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 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, data types, and descriptions of the fields.

      Partitions

      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.

      • The displayed partition information is incomplete. To view the complete partition information about a MaxCompute tenant table, run the show partitions <tablename> command.

      Preview

      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.