Contents x
    Column References
    • 24 Jan 2023
    • Print
    • Dark
      Light
    • PDF
    Contents

    Column References

    • Updated on 24 Jan 2023
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    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 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.

    image

    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