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.
Data source nameField
Field name (column)
Field Display Name
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.
(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.
Displays metadata about the table.
(1) Basic metadata
You can enter and edit metadata yourself.
This is a metadata item that is defaulted by trocco. Input is recommended.
This is a metadata item that is defaulted by trocco. Markdown notation is supported.
Related forwarding settings
Displays 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 Definitions
Displays 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.
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.
Lists the columns contained in the table. You can also view metadata about columns and manually define column references.
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.
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.
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.
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.