The Tenant Tables pane in DataStudio lets you browse tables across all workspaces in your tenant without leaving your development environment. You can filter by compute engine type and engine name, and inspect table metadata including columns, partitions, and data previews.
Supported compute engines: MaxCompute, AnalyticDB for PostgreSQL, Hologres, and E-MapReduce (EMR).
Prerequisites
Before you begin, ensure that you have:
-
A compute resource (MaxCompute, AnalyticDB for PostgreSQL, Hologres, or EMR) associated with DataStudio. See Associate a data source or a cluster with DataStudio
-
For AnalyticDB for PostgreSQL, Hologres, or EMR tables: metadata collected on the DataMap page. See Metadata collection
View tenant tables
-
Go to the DataStudio page.
Log on to the DataWorks console. In the top navigation bar, select a region. In the left-side navigation pane, choose Data Development and Governance > Data Development. Select a workspace from the drop-down list and click Go to Data Development.
-
In the left-side navigation pane, click Tenant Tables.
NoteClick the
icon in the lower-left corner to show or hide pane names. -
Select the compute engine type and engine name to view the tenant tables.
The following table describes the parameters for a MaxCompute compute engine.
Parameter Description Project The name of the MaxCompute project in the selected environment. Click the icon next to the search box to switch environments. In standard mode workspaces, tables from both the development and production environments are displayed. In basic mode workspaces, only production environment tables are displayed. The current environment is highlighted in blue. Table Name The name of the table in the selected environment. Columns Field information for the table, including the number of fields, their data types, and descriptions. Partitions Partition count and metadata for the table. Up to 60,000 partitions can be created; if a time to live (TTL) is configured, the actual count depends on the TTL. The pane shows a maximum of 10 partitions by default. Partition information is available only for MaxCompute tables. To view complete partition information, run show partitions <tablename>.Preview A preview of the table data. Available only for MaxCompute tables. External tables are not supported.