The My Data feature in Data Map gives you a centralized place to find, view, and manage the DataWorks tables you own or have access to. Filter tables by project or engine type, update table metadata, change ownership, and manage visibility — all from one page.
Some data in Data Map is updated offline (T+1), which can cause data latency. For the most accurate data, refer to your SQL query results.
Go to My Data
-
Log on to the DataWorks console. In the top navigation bar, select the target region. In the left-side navigation pane, choose Data Governance > Data Map, then click Go to Data Map.
-
In the left-side menu bar, click My Data. The Owned By Me tab is selected by default.
Manage tables
My Data has three tabs, each showing a different scope of tables:
| Tab | Tables shown | Default access |
|---|---|---|
| Owned By Me | All tables that you own | Table owner |
| Managed by Me | All tables in workspaces where you are an administrator | Workspace administrator |
| Managed by Production Account | All tables in the production account associated with the workspace where you are a member | Workspace member |
On each tab, search by keyword, environment, project/database, or visibility range to find specific tables. For each table, you can perform the following operations from the Actions column: Update Table Information, Delete, Transfer, Modify Category, and Add to Album.
The key fields are described below:
| Field | Description |
|---|---|
| Project/Database | If the table is in a different environment, a suffix indicates the environment. For example, _dev indicates the development environment. |
| Visibility | Controls who can search for and access the table. Click Update Table Information in the Actions column to change this setting. |
The Visibility field supports three settings:
-
Public within Tenant (default): All users can search for and access the table.
-
Only members in the associated workspace can search and view: Only users in the workspace where the table resides can find and view it.
-
Private: No one can search for or access the table.
Table owners and workspace administrators are not subject to these visibility controls by default.
Manage favorites
To favorite a table, open its details page and click the favorite button. Favorited tables appear under the My Favorites group on the My Data page.
To remove a table from your favorites, use either of the following methods. After removal, the table no longer appears in the My Favorites list.
-
Click Unfavorite in the row for the table on the My Data page.
-
Open the table's details page and click Unfavorite.
View and manage permissions
Use the Data Access Control module in Security Center to request and approve permissions for tables.
Transfer table ownership
Transfer one or more tables to another workspace member using the console or a SQL command.
Transfer tables in the console
On the My Data > Owned By Me page, select the tables you want to transfer and use the Batch Transfer operation.
-
Select the tables you want to transfer, then click Batch Transfer below the list.
-
In the Batch Transfer dialog box, select the destination user and click Confirm.
The destination user must be a member of the workspace where the table resides. If the destination user is not a workspace member, the transfer fails.
Transfer tables using a SQL command
Run the following command to transfer a table:
Syntax
alter table <table_name> changeowner to <new_owner>;Parameters
| Parameter | Required | Description |
|---|---|---|
table_name |
Yes | The name of the table to transfer. |
new_owner |
Yes | The new table owner. To transfer to a RAM user, use the format RAM$<UID>:<ram_name>, where UID is the Alibaba Cloud account ID and ram_name is the display name of the RAM user. |
To transfer a table to a RAM user, the RAM user must be added to the project that contains the table.
Examples
Transfer the test1 table to an Alibaba Cloud account:
alter table test1 changeowner to 'ALIYUN$xxx@aliyun.com';Transfer the test1 table to a RAM user named ram_test:
alter table test1 changeowner to 'RAM$13xxxxxxxxxxx:ram_test';