- 24 Jan 2023
- 1 Minute to read
- Print
- DarkLight
Column References
- Updated on 24 Jan 2023
- 1 Minute to read
- Print
- DarkLight
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 see a list of relationships between columns.
It is displayed by clicking the Column References tab.
In trocco, the relationship between each column is defined as a column reference.
You can select the sort order of the list.
Table names and authors are sorted in ascending order, and creation time is sorted in descending order.
(1) Filtering column references
You can filter the column references that appear in the list.
- If you want to focus your search on either user-defined or auto-defined
- Please remove the check box below the creation method as appropriate.
- To filter the scope of the search
- Please select arbitrarily from the selection items displayed at the beginning. The lower-level choices are displayed.
- In the case of BigQuery, the dataset field is displayed when you select a project, and the table field is displayed when you select a dataset.
(2) Display of ER diagram
You can check the ER diagram between the selected tables.
With the check box selected, click Open ER diagram.
(3) Delete column reference
You can delete manually created column references.
Click the icon in the red frame and click Remove this column reference.
If the TROCCO feature automatically generates a column reference, the creator is auto-defined.
You cannot delete a column reference whose author is auto-defined.