The dimension table feature allows you to create MaxCompute tables, import local data to MaxCompute tables, and edit MaxCompute tables in a visualized manner.

Prerequisites

  1. MaxCompute is activated. For more information, see Activate MaxCompute.
  2. A MaxCompute compute engine is bound to a DataWorks workspace. For more information, see Configure a workspace.
  3. A MaxCompute table is created. For more information, see Table.

Limits

  • To create a MaxCompute table in DataAnalysis, you must be an administrator, an owner, or a developer of a DataWorks workspace. For more information, see Add workspace members.
  • For a MaxCompute table that is created by using the dimension table feature, all fields in the MaxCompute table are of the STRING type. If you need to use fields of other data types, execute Data Definition Language (DDL) statements to create a MaxCompute table on the DataStudio page. For more information, see the "Create a table" section in the Table-level operations topic.

Create a MaxCompute table

  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 target workspace resides. Find the target workspace and click Data Analytics in the Actions column.
  2. On the DataStudio page, click the Icon icon in the upper-left corner and choose All Products > Data Development > DataAnalysis.
  3. On the DataAnalysis homepage, click Experience Now. The Web Excel page appears.
  4. In the top navigation bar, click Dimension.
  5. On the Dimension page, click the Create icon under New Dimension Table.
  6. In the New Dimension Table dialog box, set the parameters as required.
    Create a MaxCompute table
    Parameter Description
    Target Workspace The DataWorks workspace to which the MaxCompute table belongs.
    Table Name The name of the MaxCompute table. The MaxCompute table will be used in the production environment.
    Note The table name can contain only letters, digits, and underscores (_), and must start with a letter.
    Table Description The description of the MaxCompute table, such as the purpose or features.
    Field The fields in the MaxCompute table. Only fields of the STRING type can be added.
    Lifecycle The lifecycle of the MaxCompute table. The MaxCompute table occupies storage resources in MaxCompute. To make sure that the resources can be recycled, select a proper lifecycle for the MaxCompute table from the drop-down list. If the specified lifecycle expires, the table is deleted.
  7. Select I have known this risk and confirmed that as owner of this table, I am responsible for the subsequent changes to this table. Click OK to go to the MaxCompute table editing page to view and modify information about the table. For more information, see Edit a MaxCompute table.
    The MaxCompute table created in DataAnalysis is maintained in the production environment. As the owner of the table, you are responsible for the maintenance of the table.

View and manage a MaxCompute table

  1. Click Return in the upper-left corner of the MaxCompute table editing page or Dimension in the top navigation bar to go to the Dimension page.
    MaxCompute tables
  2. In the All Dimension Tables section of the Dimension page, select I created or Share it with me from the drop-down list in the upper-right corner to view the MaxCompute tables in the corresponding category.
    You can also share MaxCompute tables with specific users. For more information, see Share a MaxCompute table.
  3. Click the file name of a MaxCompute table, or click Edit in the Operation column of the MaxCompute table to go to the MaxCompute table editing page.
    On the Dimension page, you can perform the following operations to manage a MaxCompute table:
    • To change the owner of a MaxCompute table, perform the following steps: Find the MaxCompute table and click Change Owner in the Operation column. In the Change Owner dialog box, select an owner from the New Owner drop-down list and click OK.
    • To delete a MaxCompute table, perform the following steps: Find the MaxCompute table and click Delete in the Operation column. In the Delete message, click OK.

What to do next

After you create a MaxCompute table, go to the MaxCompute table editing page and import data to the MaxCompute table. For more information, see Import data to a MaxCompute table.