This topic describes how to view the details about a table.
On the Data Map page, click a table in any list to go to the details page of the table, as shown in the following figure.
On the details page, you can view the basic information, business information, permission information, technical information, detailed information (including the fields, partitions, and change history), output information, lineage information, reference record, and description of the table. You can also preview the table.
Apply for table permissions
For more information about how to apply for table permissions, see Apply for data permissions.
Add a table to favorites
Access DataService Studio
Click Create API in DataService Studio under the table name to go to DataService. For more information, see DataService studio overview.
In the Basic Information section, you can view the number of reads, favorites, and views. You can also check the output task, MaxCompute project name, owner name, creation time, time to live (TTL), storage capacity, description, and tags of the table.
- You can click the name of the MaxCompute project to go to the project details page.
- You can click next to Tags to add tags for the table.
In the Permissions section, you can view your permissions next to My Permissions and click More to go to Search for data.
In the Technical Information section, you can view the technical type, last DDL change time, last data change time, last data view time, and compute engine information.
- The default time format is yyyy-mm-dd hh:ss:mm.
- Click View next to Compute Engine. A dialog box appears, displaying information about the compute engine.
On the Content tab, you can view the metadata of the table, including the definition, popularity, and security level. You can also check the table structure changes and whether a field is a primary key or foreign key.
- Field information
On the Fields tab, you can view the name, type, description, and popularity of fields. You can also check whether a field is a primary key or foreign key.
- Edit Field Security Level: You can click this button to go to the corresponding node. If you do not have the corresponding permission, you are prompted to apply for it.
- Download Field Information: You can click this button to download the field information.
- View DDL Statement: If you click this button, a dialog box appears, displaying the related table creation statements.
- Generate SELECT Statement: If you click this button, a dialog box appears, displaying the related SELECT statements.
- Partition information
On the Partitions tab, you can view the name, number of records, storage volume, creation time, and last update time of each partition of the table.
- Change history
On the Change History tab, you can view the change description, change type, granularity, time, and operator involved in each change. You can also select a change type from the drop-down list to filter change records.
On the Lineage tab, you can view data lineage and interaction between tables.
- Table lineage
On the Table Lineage tab, you can search for the ancestor and descendant tables of a table based on the GUID, as shown in the following figure.
- Field lineage
On the Field Lineage tab, you can specify the field name to search for the ancestor and descendant tables of a table, as shown in the following figure.
- Foreign key references
On the Foreign Key References tab, you can check the number of users who reference the table.
- References in clauses
The References in Clause tab displays the table reference record by using a line chart, as shown in the following figure.
- On the Data Preview tab, you can preview the data information of the current table.
- To preview a table in the production environment, you must have the required permission. If you do not have the permission, you are prompted to apply for it.
On the Usage Notes tab, you can edit the description for the table and view the related history versions and Markdown syntax. You can also learn related information based on the data business description.