Table Info
- 24 Jan 2023
- 5 Minutes to read
-
Print
-
DarkLight
Table Info
- Updated on 24 Jan 2023
- 5 Minutes 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 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
(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 nameField | table) | Field name (column) |
|---|---|---|
| Google Analytics | - | Field Display Name |
| kintone | App name | Field Name |
| Salesforce | Label (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.
(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.
(1) Basic metadata
You can enter and edit metadata yourself.
| Item name | remarks |
|---|---|
| Logical name | This is a metadata item that is defaulted by trocco. Input is recommended. |
| explanation | 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.
(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.
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.
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.
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.
- For more information about views, see Overview of Views.
Click anywhere on the record to view the record details.
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.
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.
Was this article helpful?