--- title: "Data Catalog Setting" slug: "data-catalog-settings-v1" updated: 2024-09-10T11:26:33Z published: 2024-09-10T11:26:33Z canonical: "documents.trocco.io/data-catalog-settings-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. # Data Catalog Setting ## summary Click on **Data Catalog Setting** in the upper right corner of the screen. Data Catalog Settings allow you to configure various settings related to the Data Catalog. ![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-catalog-settings-v1-2024-08-29-18-3-0.png) - [TROCCO Basic Metadata Settings](/docs/en/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) - [Templates for user-defined metadata](/docs/en/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 Import](/docs/en/data-catalog-settings-v1#%E3%83%A1%E3%82%BF%E3%83%87%E3%83%BC%E3%82%BF%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88) - [Data Store Coordination Management](/docs/datastore-integrations-v1) ## TROCCO Basic Metadata Settings Set the fields to be displayed in the [column information](/docs/table-information-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E6%83%85%E5%A0%B1). The default settings are as follows - **Logical name**: Display - **Explanation**: Not shown ## Templates for user-defined metadata Set the fields to be populated with **user-defined metadata** for each table column. Notes on templates for user-defined metadata - **Only one** template for user-defined metadata can be created per table column. - Fields added to the template **cannot be deleted later**. - Fields that are set to **be****required cannot be made mandatory later**. | item name | indispensable | remarks | | --- | --- | --- | | Template Name | ✓ | Enter a template name. | | Template Type | ✓ | Select either from a table or a column. | | Field Name | ✓ | Enter a field name. | | Tip. | - | You can enter a hint for the field. The information entered in this field will be displayed on the user-defined metadata entry screen. | | data type | ✓ | Select one of the following`String``Text(Markdown)``Integer``Boolean`A string entered as `a``String` or `Text (Markdown) type` is the target string in [a table column search](/docs/metadata-search-function-v1). | | require entry | - | If this item is enabled, when editing user-defined metadata, the value of the corresponding field must be entered before it can be saved. **This item cannot be changed later.** | ## Metadata Import CSV files can be used to import **basic metadata** values. The results of the import can also be viewed from the import history at the bottom of the screen. ![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-catalog-settings-v1-2024-08-29-18-3-1.png) ### Metadata Import Restrictions Subject of metadata import Metadata import using CSV files is supported **only for basic metadata**. Import of other metadata is not supported. Character encoding of CSV file **UTF-8 is** recommended. For character codes other than UTF-8, some characters may not be readable. File size limit for CSV upload The maximum file size for CSV files that can be uploaded is **100 MB**. if metadata has already been entered If metadata values have already been entered, the imported values will overwrite the existing values. ### CSV file format Click on **Download CSV Template**. Edit the downloaded CSV file accordingly and perform upload and import. A CSV with the field name entered in the first line will be downloaded. Enter metadata as appropriate on the second and subsequent lines. Note that the structure of the CSV file will vary depending on your data store and the tables or columns to be imported. Below is a description of the CSV file structure for each data store. #### If you are using a BigQuery data store For the first line of the CSV file, enter the following - Basic Table Metadata - `project_id,dataset_id,table_id,logical_name,description` - column basic metadata - `project_id,dataset_id,table_id,column_id,logical_name,description` Enter the second and subsequent lines of the CSV file based on the table below. | column name | indispensable | Information to be entered | | --- | --- | --- | | `project_id` | ✓ | Project Name | | `dataset_id` | ✓ | Data Set Name | | `table_id` | ✓ | table name | | `column_id` | ✓* | Column name associated with table Required only when importing **basic column metadata** | | `logical_name` | - | Value you want to enter in the Logical Name field | | `description` | - | Value you want to enter in the Description field | #### If you are using Snowflake's data store For the first line of the CSV file, enter the following - Basic Table Metadata - `database_name,schema_name,table_name,logical_name,description` - column basic metadata - `database_name,schema_name,table_name,column_name,logical_name,description` Enter the second and subsequent lines of the CSV file based on the table below. | column name | indispensable | Information to be entered | | --- | --- | --- | | `database_name` | ✓ | Database Name | | `schema_name` | ✓ | schema name | | `table_name` | ✓ | table name | | `column_name` | ✓* | Column name associated with table Required only when importing **basic column metadata** | | `logical_name` | - | Value you want to enter in the Logical Name field | | `description` | - | Value you want to enter in the Description field | Example of CSV file input The following is an example CSV file used for importing basic table metadata from a BigQuery data store. ![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-catalog-settings-v1-2024-08-29-18-3-2.png) ### If import fails Click **View Error Log in****Import History** to see the cause of the error. ![data-catalog-settings-v1-2024-08-29-18-3-3](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-catalog-settings-v1-2024-08-29-18-3-3.png) ## Data Store Coordination Management See [Data Store Coordination Management](/docs/datastore-integrations-v1).