In Data Map, you can search for fields or tables by using keywords that are contained in a table name, table description, field name, field description, tag, or the name or description of a metric that is created in Data Modeling. You can also search for tables by category, project, or database.

Prerequisites

If a MaxCompute project is associated with your workspace, you can directly search for tables in the MaxCompute project. If you want to search for tables in another type of data source in Data Map, you must use the metadata collection feature to import the metadata of the data source to Data Map before you can search for tables in the data source. For more information, see Data discovery.

Go to the page for searching for tables

  1. Log on to the DataWorks console and go to the homepage of DataMap. For more information, see Go to the homepage of DataMap.
  2. In the top navigation bar of the DataMap page, click All Data.
  3. Select the Table category above the search box. The page for searching for tables appears.

Search for tables

Search for tables
Area Description
1
You can click the Filter icon in the search box to select a data source type and search for tables in the data source by using keywords that are contained in the names, descriptions, or tags of the tables. You can also click Fields on the left side and search for fields in the data source by using keywords that are contained in the names or descriptions of the fields, or in the names or descriptions of metrics that are created in Data Modeling.
Note The following data source types are supported: MaxCompute, E-MapReduce, Hologres, AnalyticDB for MySQL 2.0, AnalyticDB for MySQL 3.0, OSS, AnalyticDB for PostgreSQL, OTS, PostgreSQL, MySQL, SQL Server, and Oracle.
2 You can search for your desired tables from the search results by specifying filter conditions such as category, database name, owner, and project. The filter conditions that are displayed on the page vary based on the selected data source type. For information about how to configure table categories, see Manage table categories.
Note If you select the MaxCompute data source type, you can search for your desired tables in a MaxCompute project by environment and owner. If you select another data source type such as E-MapReduce (EMR) or Cloudera's Distribution including Apache Hadoop (CDH), you can search for your desired tables by cluster.
3 You can view the tables in the current data source and perform the following operations on the tables:
  • Apply for Permission: You can request permissions on the table in Security Center and view the permission request record in DataMap. For more information, see Request permissions on tables.
  • Add to Collection: You can add the table to the desired data album and manage the table on the details page of the data album. For more information, see Data album.
  • Add to Favorites or Remove from Favorites: You can add the table to favorites or remove the table from favorites.
  • View Lineage: You can view the lineage information about the table. The lineage information includes the lineage between this table and other tables and the lineage between fields in this table and fields in other tables. The lineage information is obtained by parsing the data of scheduling jobs and the data flow information. The lineage that is generated by manual operations, such as ad hoc queries, is not included. For more information, see View the details of a table.
  • View DDL: You can move the pointer over the more icon and select View DDL. In the Generate DDL Statement message, view or copy the DDL statement that is used to create the table.