Contents x
ER Diagram/JOIN analysis
  • 24 Jan 2023
  • 1 Minute to read
  • Print
  • Dark
    Light
Contents

ER Diagram/JOIN analysis

  • Updated on 24 Jan 2023
  • 1 Minute to read
  • Print
  • Dark
    Light
Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

In trocco's data catalog, you can check the ER diagram between the specified tables.
It also supports JOIN analysis, which allows you to visually check the relationship between two tables.

Technical basis for ER diagram display and JOIN analysis

The relationship information between ER diagrams and tables that enables JOIN analysis is made possible by trocco's automatic metadata integration function. You can also set up your own relationships between tables.
For more information, see Manual definition of column references in Column information.

ER diagram

Click the ER Diagram tab and view the display table by selecting a table from the filter.
image

When you mouse over a table, the line with the table involved is highlighted.
image

How to display an ER diagram

ER diagrams can also be displayed from the column reference list.
For more information, see Column references.

How to view a JOIN analysis

Click the midpoint of the line connecting the tables to display the JOIN analysis.
image

JOIN Analysis

In JOIN analysis, you can check the information you want to check when joining, such as the JOIN key, the number of uniques, and the number of nulls in two tables.
You can also visually see the number of rows generated when joining two tables with a Venn diagram.
image

You can also select any table join type in the JOIN preview to see a preview of the joined tables.
Queries for table joins are also displayed.
You can also copy a query by clicking the icon in the red frame below.
image

Was this article helpful?
What's Next