This topic describes how to use MaxCompute Studio to view tables, views, functions, and resources in projects.

Prerequisites

A MaxCompute project is connected. For more information, see Manage project connections.

Background information

In the Project Explorer tool window, you can view tables, views, functions, and resources in MaxCompute projects that are connected.

Browse and update project data

  1. Go to the MaxCompute Studio page. In the left-side navigation pane, click Project Explorer to view your connected MaxCompute project.
    %%
  2. Click the drop-down arrow on the left side of the Tables & Views, Functions, or Resources node to view all tables, views, functions, or resources in the project.
    Note To perform this operation, you must have the DESC TABLE permission on the MaxCompute project.
  3. In the toolbar, click the $$ icon to update the local metadata.
    Note MaxCompute Studio downloads the metadata of MaxCompute projects to a local device. When the metadata of a MaxCompute project is updated, you must trigger a refresh to reload the changed metadata to the local device.

View details about tables or views

  1. In the Tables & Views node tree, click a table name to expand the node. You can then view the columns and column types of the table.
    **
  2. Right-click the table name and select Show table detail to view the table details. The table details include the owner, size, column information, and schema of the table.
    Table information
  3. Right-click the table name and select Find usages to query the scripts in which the table is used.

View function details

  1. In the Functions node tree, click the UserDefined node to view the functions that you have created.
    **
    Note The Builtin node under the Functions node tree classifies the built-in functions of the system. You can double-click a function to display the usage notes of the function. For more information about the built-in functions, see Builtin functions.
  2. Double-click a function to display the code of the function.

View resource details

Expand the Resources node tree to view the created resources. Resource