Column References
  • 24 Jan 2023
  • Dark
  • PDF

Column References

  • Dark
  • PDF

Article Summary


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.


In Trocco's Data Catalog, you can see a list of relationships between columns.
It is displayed by clicking the Column References tab.

Column reference

In trocco, the relationship between each column is defined as a column reference.


List order

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.

About Auto-Generated Column References

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.

Was this article helpful?

What's Next