View and analyze relationships between data (ER diagram, JOIN analysis)
- 17 Jul 2024
- Print
- PDF
View and analyze relationships between data (ER diagram, JOIN analysis)
- Updated on 17 Jul 2024
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
summary
In TROCCO's data catalog, you can see ER diagrams between specified tables.
It also supports JOIN analysis, which allows you to visually check the relationship between two tables.
Conditions for tables that allow JOIN analysis
JOIN analysis can be performed only between tables with defined column references.
For information on how to define column references, see Manual Definition of Column References.
Automatic definition of column references
Tables transferred to the data store using a specific TROCCO source connector will automatically have column references defined.
For more information, see Connectors subject to automatic definition of column references.
ER diagram
It is displayed by clicking on the ER Diagram tab and selecting the table from the Display Tables filter.
Mouse over a table to highlight the line to the related table.
How to display JOIN analysis
Mouse over the midpoint of the line connecting the tables to see the JOIN key.
Click on the midpoint as it is, and the JOIN analysis will be displayed.
JOIN Analysis
JOIN analysis allows you to check the information you want to see when joining two tables, such as the JOIN key, number of uniques, and number of nulls.
The number of rows generated when joining two tables can also be visually confirmed by a Venn diagram.
Click on View JOIN Analysis to perform the analysis.
You can also choose any table join type in the JOIN preview to see a preview of the joined tables.
A query for table joins is also displayed.
Queries can also be copied by clicking on the icons in the red box below.
Was this article helpful?