Viewing Tables

Querying the Model View

After creating a table in an ER model, you can query the table models in the list view or model view. The created tables are displayed in the list view by default. You can switch to the model view if you like.

1. On the DataArts Architecture page, choose Models > ER Modeling in the left navigation pane.
2. In the ER model tree, select a model other than the OBS type, expand it, and select an object.
3. On the ER Modeling page, all created tables are displayed in the list view by default. You can click the Model View in the upper right corner on the ER Modeling page to change the view mode. You can click List View to switch back to the table list.
   Figure 1 Model view
   

   The following functions are supported in the model view:

   • Double-click a table name to view the table details.
   • Click Export in the upper left corner to export the model view as an image.
   • Enter a table name in the search box in the upper right corner to quickly find the table you want to view.
   • represents zoom in, zoom out, full screen, switch between physical and logical models, refresh, and canvas display, respectively.

Viewing Table Details and Previewing an SQL Statement

1. On the DataArts Architecture page, choose Models > ER Modeling in the left navigation pane.
2. On the model overview page, click the card of the required logical model, and select a subject in the subject directory. All tables under the subject are displayed in the list on the right.
3. In the table list, select a table, and choose More > Preview SQL in the Operation column to preview or copy the SQL statement. Then, click OK to return to the previous page.
   Figure 2 ER model list
   

4. In the table list, click a table name to access the table details page and view the table details, relationship diagrams, publish history, and review history.
   Figure 3 Relationship diagrams
   

Viewing Publish History

After a table is published, you can view its publish history, version comparisons, and publish logs. If a table fails to be published, or a data asset or data quality job fails to be synchronized, you can view the publish log to troubleshoot the fault and publish or synchronize it again.

1. On the DataArts Architecture page, choose Models > ER Modeling in the left navigation pane.
2. On the model overview page, click the card of the required logical model, and select a subject in the subject directory. All tables under the subject are displayed in the list on the right.
3. In the table list, locate the target table, and choose More > View History. On the page displayed, you can view the table publish history, version comparisons, and publish logs.
   Figure 4 Viewing publish history