Contents x
    Table Info
    • 24 Jan 2023
    • 5 Minutes to read
    • Print
    • Dark
      Light
    Contents

    Table Info

    • Updated on 24 Jan 2023
    • 5 Minutes to read
    • Print
    • Dark
      Light
    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 the Table Info tab, you can view various information about the table and each column associated with the table.
    The Table Info tab consists of the following four functions:

    • Table information
      • You can review and edit the metadata in the table.
    • Column Information
      • You can check and edit the metadata of each column associated with the table.
      • You can view summary statistics and data previews.
      • You can manually set the referential relationships between columns.
    • preview
      • You can see a preview of the table.
      • You can view summary statistics for each column.
    • Column lineage
      • You can visually check the lineage of the column.

    Table information common function

    image

    (1) Table name

    Displays the table name.

    (2) Logical name

    Displays the logical name.

    Where the logical name appears

    The logical name appears in various places in the Data Catalog, not just in this location.

    • Next to the right of each table name and column name in the search results
    • Directly under the table name of the filter table
    • Logical name column values for column information
    • Directly below the column name in the preview
    • Directly below the table name in the ER diagram
    • In the input completion function of the query editor
    Values treated as logical names
    • If the logical name of the basic metadata is entered
      • The logical name of the base metadata is treated as a logical name.
    • If you do not entera logical name for the basic metadata
      • The following field name values in the metadata about the data source are treated as logical names.

    name (

    Data source nameFieldtable)Field name (column)
    Google Analytics-Field Display Name
    kintoneApp nameField Name
    SalesforceLabel (singular)Japanese column names
    Yahoo! Search Ads-Japanese display name

    (3) Favorite button

    You can mark a table as a favorite.
    Tables registered as favorites are stored in the favorites immediately below the display table filter.

    (4) Query button

    Launch the query editor.
    The table that was open in the Table Info tab is launched with the FROM clause specified.
    image

    (5) Switch tabs

    Toggle the features that are displayed. Click the name of the feature you want to browse.

    (6) Table filter

    Filter the table. Enter any table name.

    Table information

    Displays metadata about the table.
    image

    (1) Basic metadata

    You can enter and edit metadata yourself.

    Item nameremarks
    Logical nameThis is a metadata item that is defaulted by trocco.
    Input is recommended.
    explanationThis is a metadata item that is defaulted by trocco.
    Markdown notation is supported. 
    Related forwarding settingsDisplays the transfer settings used to transfer the corresponding table.
    This item is displayed only for tables transferred using trocco's transfer settings.
    By clicking the link, you can display the transfer setting details screen.
    Related Data Mart DefinitionsDisplays the datamart definition used to create the table.
    This item is displayed only for tables that use the data transfer mode of the data mart function of trocco.
    By clicking the link, you can display the datamart definition details screen.
    If you're using the Teams feature

    In order to display the details screen of the related transfer settings and related data mart definitions, you must have a role of Viewer or higher.
    For more information, see About team features.

    (2) Link to column reference list

    Click the link to display a list of column references defined in the table.

    (3) User-defined metadata

    Customers can enter and edit metadata in fields created in advance with the user-defined metadata template.

    Templates for user-defined metadata

    You can define the field name, data type, whether or not it is required, etc.
    You can configure templates in your Data Catalog settings.

    (4) Metadata about the data store

    Metadata automatically retrieved by TROCCO's catalog data extraction function.

    Metadata about the datastore
    • On the screen, the corresponding datastore name is displayed.
      • Example: Metadata about BigQuery
    • Depending on your datastore, different metadata items are retrieved.
      For details on the metadata retrieved by each data store, refer to the list of metadata to be acquired.

    (5) Metadata about the data source

    Metadata automatically retrieved by TROCCO's automatic metadata integration feature.

    Metadata about the data source
    • On the screen, the corresponding data source name is displayed.
      • Example: Metadata about Salesforce
    • Depending on your data source, different metadata items are retrieved.
    Conditions for automatically retrieving metadata about data sources

    Metadata about a data source is automatically retrieved when all of the following conditions are met:

    • The source connector supports TROCCO's automatic metadata integration feature.
    • It is a table created via the data transfer function of trocco.

    For details on connectors that support TROCCO's automatic metadata integration function, see "Data Sources" of supported connectors.

    Column Information

    Lists the columns contained in the table.
    You can also view metadata about columns and manually define column references.
    image

    Column fields for column information

    By default, three column items are displayed: column name, data type, and logical name.
    The column items displayed in the column information can also be set in the trocco basic metadata settings.

    Column information details

    Click the details of each column to view metadata about that column.
    You can also view summary statistics and data previews.
    image

    Display items for summary statistics

    Depending on the data type of the column, different fields are displayed.

    Specifications for summary statistics and data preview

    Executing queries on customer-managed datastores and displaying the execution results.
    Therefore, you will be billed for your datastore based on the query execution size.  Thank you for your understanding.

    Sampling queries when using BigQuery

    When using BigQuery, if the amount charged per query exceeds 10 yen (about 15.5 GB in file size), the data is sampled and then the query is executed.

    Automatic transfer of metadata associated with columns


    This specification applies only when using BigQuery.

    Columns in tables generated using the data mart function of Trocco can automatically inherit metadata related to the data source of the generating column.
    However, in order to automatically take over metadata, the following conditions are met.

    Conditions for automatic transfer of metadata associated with columns
    • In the data mart definition, the column value is not processed.
    • Data transfer mode is used as the query execution mode of the datamart definition.
      • Tables generated using free-description mode are not subject to transfer.

    Defining column references manually

    You can manually set the relationships between columns. Click Add Column Reference.
    Select the table name and column name for which you want to set the relationship, and click Create.

    Manually defined column references and ER diagrams and JOIN analysis

    In trocco, relationships between tables for which column references have been manually defined are also depicted in ER diagrams.
    It also supports JOIN analysis between tables with manually defined column references.

    preview

    Displays a preview of the table. You can also check the data type of each column and summary statistics.
    It also supports a sort filter function.
    image

    Notes on previews
    • You cannot combine sort filter functions on multiple columns.
    • For columns with more than 200 unique values, the filter function is not available.
    • You cannot display a preview for BigQuery views.

    Click anywhere on the record to view the record details.
    image

    Column lineage


    This specification applies only when using BigQuery.

    Displays how the columns contained in the table are generated.
    When you click a column, the columns that are connected to that column and their routes are highlighted.

    Notes on column lineage

    Column lineage is displayed only for tables that meet all of the following conditions:

    • It is a table generated using trocco's data mart function.
    • Data transfermode is used as the query execution mode of the datamart definition.
      • For tables generated using free description mode, column lineage is not displayed.
    Types of lines connecting columns

    There are two types: dotted and solid.

    • A solid line means that the data was generated as is, unprocessed.
    • A dotted line means that the processed data has been generated.

    image

    By default, lineage is displayed with this table as the end point.
    If you want to switch the display to lineage starting from this table, click the icon in the red frame below.
    image

    Was this article helpful?
    What's Next