---
title: "Understanding Data (Table Information)"
slug: "table-information-v1"
updated: 2024-10-30T09:38:59Z
published: 2024-10-30T09:38:59Z
canonical: "documents.trocco.io/table-information-v1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documents.trocco.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Understanding Data (Table Information)

## summary

Table Information allows you to edit the metadata associated with a table and view previews and renditions of the table.

In Table Information, you can switch between screens with the following four tabs.

- **[Table Information](/docs/table-information-v1#%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E6%83%85%E5%A0%B1)**
  - You can view and edit metadata in the table.
- **[Column Information](/docs/table-information-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E6%83%85%E5%A0%B1)**
  - You can view and edit the metadata for each column associated with the table.
  - View **summary statistics** and **data previews**.
  - Reference relationships between columns can be set manually.
- **[preview](/docs/table-information-v1#%E3%83%97%E3%83%AC%E3%83%93%E3%83%A5%E3%83%BC)**
  - You can see a preview of the table.
  - **Summary statistics for** each column can be viewed.
- **[column lineage](/docs/table-information-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E3%83%AA%E3%83%8D%E3%83%BC%E3%82%B8)**
  - Visual confirmation of column linage.

## Common screen

![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/table-information-v1-2024-08-29-2-41-0.png)

#### 1. table name

The table name (physical name) is displayed.

#### 2. logical name

The logical name of the table is displayed. If no logical name is defined, nothing is displayed. For more information about logical names, see [logical names](/docs/catalog-glossary-v1#%E8%AB%96%E7%90%86%E5%90%8D).

#### 3. favorite button

Tables can be registered as favorites. Tables registered as favorites are stored in the **favorites** in the **table list**.

#### 4. query button

Launch Queriedita. The table opened in the Table Info tab will be launched with the FROM clause specified.

#### 5. screen switching

Switches the screen to be displayed.

#### 6. table list

The table list is displayed. Select the table for which you wish to edit or reference metadata. Entering a filter will narrow the table.

## Table Information

Displays metadata about the table. ![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/table-information-v1-2024-08-29-2-41-1.png)

#### 1. basic metadata

You can enter a **logical name and****description**. We recommend that you enter information that will help identify the asset in **the logical name** and descriptive information about the asset in **the description**. For more information about logical names, see [logical names](/docs/catalog-glossary-v1#%E8%AB%96%E7%90%86%E5%90%8D).

#### Related ETL Configuration and Data Mart

For tables that have been transferred or loaded using TROCCO, information on the ETL Configuration or Data Mart Configuration used will be displayed. Clicking on the link will bring up the ETL Configuration Details screen.

#### 2. link to column reference list

Clicking on the link will display a list of [Column Setting references](/docs/column-reference-v1) defined in the table in question.

#### User-defined metadata

Customers can enter and edit their own metadata in fields previously created [in the template for user-defined metadata](/docs/data-catalog-settings-v1#%E3%83%A6%E3%83%BC%E3%82%B6%E3%83%BC%E5%AE%9A%E7%BE%A9%E3%83%A1%E3%82%BF%E3%83%87%E3%83%BC%E3%82%BF%E7%94%A8%E3%83%86%E3%83%B3%E3%83%97%E3%83%AC%E3%83%BC%E3%83%88).

#### Metadata about the datastore

This metadata is obtained as a side effect of [the automatic asset capture function](/docs/automatic-assets-update-v1). Depending on your data store, the metadata items retrieved will vary. For details on the metadata obtained from each data store, please refer to [the metadata details about the data store](/docs/datacatalog-supported-functions-list-v1#%E3%83%87%E3%83%BC%E3%82%BF%E3%82%B9%E3%83%88%E3%82%A2%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E3%83%A1%E3%82%BF%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E8%A9%B3%E7%B4%B0).

#### Metadata about the data source

Metadata automatically acquired by [the automatic metadata acquisition function](/docs/automatic-metadata-fetched-v1). For more information on the conditions under which this item appears, please refer to [the metadata about the data source](/docs/automatic-metadata-fetched-v1#%E3%83%87%E3%83%BC%E3%82%BF%E3%82%BD%E3%83%BC%E3%82%B9%E3%81%AB%E9%96%A2%E3%81%99%E3%82%8B%E3%83%A1%E3%82%BF%E3%83%87%E3%83%BC%E3%82%BF).

## Column Information

Lists the columns contained in the table. Click **Details** to view metadata about the column. Click **Add Column Reference** to manually [Column Setting](/docs/column-reference-v1).

![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/table-information-v1-2024-08-29-2-41-2.png)

              column item of column information

              

By default, three column items are displayed: **column name**, **data type**, and **logical name**. The column items to be displayed in the column information can be set in [the TROCCO Basic Metadata Settings](/docs/data-catalog-settings-v1#trocco%E5%9F%BA%E6%9C%AC%E3%83%A1%E3%82%BF%E3%83%87%E3%83%BC%E3%82%BF%E8%A8%AD%E5%AE%9A).

### Column Information Details

Clicking on the **details of** each column will display metadata about the column in question. **Summary statistics** and **data previews are also** available.

              Summary statistics and data preview not available

              

Both summary statistics and data previews are treated as **real data**. See [Real Data](/docs/catalog-glossary-v1#%E5%AE%9F%E3%83%87%E3%83%BC%E3%82%BF) for more information on the definition of real data and viewing privileges.

![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/table-information-v1-2024-08-29-2-41-3.png)

### Manual Column Setting

Relationships between columns can be set manually. Click on **Add Column Reference**. Select the table and column names for which you want to set up relationships and click **Create**.

              What is a column reference?

              

**A column reference** refers to the correspondence between columns. Tables with Column Setting can be [JOIN analyzed in the ER Diagram](/docs/erd-and-join-v1).

## preview

Displays a preview of the table. You can also check the data type of each column and **summary statistics**. Sorting and filtering functions are also supported.

![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/table-information-v1-2024-08-29-2-41-4.png)

              If you cannot view the preview

              

Previews are treated as **real data**. See [Real Data](/docs/catalog-glossary-v1#%E5%AE%9F%E3%83%87%E3%83%BC%E3%82%BF) for more information on the definition of real data and viewing privileges.

              Warning about preview

              

- Sort and filter functions cannot be combined for multiple columns.
- The filter function is not available for columns with more than 200 unique values.
- Previews cannot be displayed for BigQuery views.
  - For more information about views, see [View Overview](https://cloud.google.com/bigquery/docs/views-intro).

## column lineage

Displays the generation path of the columns contained in the table. Clicking on a column highlights the columns that are connected to that column and their paths.

              Warning about column linage

              

Column linage will appear only for tables that satisfy both of the following conditions

- The table was generated using TROCCO's data mart feature.
- **Data Transfer Mode is used as** the query execution mode for Data Mart Configuration.
  - Column linage is not displayed for tables generated **using free description mode**.

              Type of line connecting columns

              

There are two types of lines: dotted and solid.

- A **solid line** means that the data was generated as is, without processing.
- A **dotted line** means that processed data has been generated.

![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/table-information-v1-2024-08-29-2-41-5.png)

By default, the **linage** is displayed **with this table as the end point**. To switch the display to the **linage starting from this table**, click the icon in the red frame below. ![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/table-information-v1-2024-08-29-2-41-6.png)