View and manage My Data, view and manage permissions, batch transfer tables - DataWorks

The My Data feature offers a central place to quickly find, view, and manage DataWorks tables that you own or can access. You can filter tables by project and engine type, and perform routine management tasks such as updating table information and transferring ownership.

Notes

Some data in Data Map is updated offline (T+1), which can cause data latency. For the most accurate data, refer to the results of your SQL queries.

Go to My Data

Log on to the DataWorks console. In the target region, click Data Governance > Data Map in the left-side navigation pane. On the page that appears, click Go to Data Map.
In the navigation pane on the left, click My Data. The My Data > Owned by Me page appears by default.

The left-side secondary navigation of the My Data page is divided into two groups, which are shown or hidden dynamically based on your permissions:

My Data group: includes Owned by Me, Managed by Me, Managed by Production Account, and My Favorites.
My Tools group: includes Refresh Table Metadata, Approver Governance, and Transfer Logs.

Manage My Data

You can view the tables you own and search for them by criteria such as Keyword, Environment, Project/Database, and visibility range to view table details and perform operations.

Owned by Me: Displays all tables for which the current user is the table owner.
Managed by Me: Displays all tables in workspaces where you are a workspace administrator.

Note
Before you can view E-MapReduce tables in Managed by Me, you must first bind the E-MapReduce engine using "Security Mode"; otherwise, the list will be empty.
Managed by Production Account: Displays all tables from the production account associated with your workspace.

You can view basic table information and perform operations such as Update Information, Delete, Transfer, Modify Category, and Add to Album. The key fields are described as follows:

Name

Description

Project Name/Database

If your table is in a different environment, it has a related suffix. For example, _dev indicates the development environment.

Visibility

Click Update Table Information in the Actions column to modify the Visibility.

Public Within Tenant: The default setting. Anyone in the tenant can search for and access the table.
Only members in the associated workspace can search and view.: Only members of the workspace where the table resides can search for and view it.
Private: No one can search for or access the table.

Important

By default, these visibility settings do not apply to table owners or workspace administrators.

Manage My Favorites

On a table's details page, you can click the favorite button to add the table to My Favorites. After you add a table to your favorites, you can view it in the My Favorites group on the My Data page.

You can unfavorite a table in two ways. After a table is unfavorited, it is removed from the My Favorites list on the My Data page.

Click Remove from Favorites in the table's row.
On the details page of a favorited table, click Remove from Favorites.

View and manage permissions

In the Data Access Control module of the Security Center, you can apply for and approve table permissions.

Batch transfer tables

You can transfer tables to other members in the same workspace.

Method 1: Use the console

On the My Data > Owned by Me page in Data Map, you can view the tables that you own. Below the table list, you can find options for batch operations. If you need to transfer multiple data tables, use the Batch Transfer operation.

Select the tables that you want to transfer, and then click Batch Transfer below the list.
In the Batch Transfer dialog box, select the destination user and click Confirm.

Note
Ensure the destination user is a member of the workspace where the table resides, as the transfer will fail otherwise.

Method 2: Use the CLI

Alternatively, you can transfer a table by running a command to change its owner.

Syntax

alter table <table_name> changeowner to <new_owner>;

Parameters
- table_name: required. The name of the table whose owner you want to change.
- new_owner: required. The new owner of the table. If you want to change the owner of a table to a RAM user, you must set this parameter to a value in the RAM$<UID>:<ram_name> format. UID indicates the ID of the Alibaba Cloud account and ram_name indicates the display name of the RAM user.
  Note
  If you want to change the owner of a table to a RAM user, make sure that the RAM user is added to the project to which the table belongs.
Examples
- Change the owner of the test1 table to ALIYUN$xxx@aliyun.com.
```
alter table test1 changeowner to 'ALIYUN$xxx@aliyun.com';
```
- Change the owner of the test1 table to a RAM user named ram_test.
```
alter table test1 changeowner to 'RAM$13xxxxxxxxxxx:ram_test';
```

Approver Governance

For more information, see Approval owner administration (Beta).

Transfer Logs

For transfer operations performed in Owned by Me, Managed by Me, or Approver Governance, go to My Tools > Transfer Logs in the left navigation pane. On this page, you can filter historical transfer tasks by Data Type (currently MaxCompute only) and Transfer Task ID, view fields such as Operated By, Status, Started At, and Ended At, and check the success or failure details of each batch transfer. For field descriptions, see View transfer logs.

Important

Transfer logs are retained for 15 days only. After 15 days, you can view historical transfer records on the Table Details > Details > Change Records tab.

Refresh Table Metadata

When a table's metadata has not been synchronized to Data Map in time, you can manually trigger metadata synchronization for the specified table on the My Tools > Refresh Table Metadata page in the left navigation pane. Three engines are supported—MaxCompute, E-MapReduce, and DLF—with different input methods for each. For detailed steps, see the "Metadata not synchronized" troubleshooting solution in Metadata retrieval.