view and manage my data,view and manage permissions,change multiple table owners at the same time - DataWorks

The My Data feature provides a centralized view for you to quickly find, view, and manage DataWorks tables that you own or have permissions on. You can filter tables by project or engine type and perform routine management tasks, such as updating table information and changing ownership.

Notes

Some data in Data Map is updated offline (T+1), which can result in 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 top navigation bar, select the desired region. In the left-side navigation pane, choose Data Governance > Data Map. On the page that appears, click Go to Data Map.
In the left-side menu bar, click My Data. The My Data > Owned By Me page appears by default.

Manage my data

You can view the tables that you own. You can also search for tables by criteria such as keyword, environment, project/database, and visibility range to view table details and perform operations.

Owned by Me: Displays all tables that you own.
Managed by Me: Displays all tables in the workspaces where you are an administrator.
Managed by Production Account: Displays all tables in the production account that corresponds to the workspace where you are a member.

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

Name

Description

Project/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. All users can search for and access the table.
Only members in the associated workspace can search and view: The table is visible to and can be searched only by users in the workspace where the table resides.
Private: No one can search for or access the table.

Important

Table owners and workspace administrators are not subject to these permission controls by default.

Manage my favorites

When you view the details of a table, you can click the favorite button on the table details page 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 remove a table from your favorites in two ways. After you remove a table, it is no longer displayed in the My Favorites list on the My Data page.

Click Unfavorite in the row for the table.
On the details page of a favorited table, click Unfavorite to remove the table from your favorites.

View and manage permissions

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

Change multiple table owners at the same time

You can use the change owner operation to transfer a table to another member in the workspace.

Method 1: Change the table owner in the console

On the My Data > Owned By Me page in Data Map, you can view the tables that you own. Batch operations are available below the list of tables. To transfer multiple tables, use the Batch Transfer operation.

Select the tables that you want to transfer, and click Batch Transfer below the list.
In the Batch Transfer dialog box, select the destination user and click Confirm.
Note
Ensure that the destination user is a member of the workspace where the table resides. This ensures that the transfer can proceed smoothly. If the destination user is not a member of the workspace, the transfer fails.

Method 2: Change the table owner using the command line

You can also change the owner of a table by running a transfer command.

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';
```

Approval owner administration

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