Using the Schema Editor - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13

The Schema Editor details all fields of the selected table. With the schema type of the table set to Built-In, you can modify the schema of the table.

Use the tool bar below the schema table, to add, move or remove columns from the schema.

You can also load a schema from the repository or export it into a file.

Metadata

Description

Column

Column name as defined on the Map Editor schemas and on the Input or Output component schemas.

Key

The Key shows if the expression key data should be used to retrieve data through the Join link. If unchecked, the Join relation is disabled.

Type

Type of data: String, Integer, Date, etc.

Note: This column should always be defined in a Java version.

Length

-1 shows that no length value has been defined in the schema.

Precision

Defines the number of digits to the right of the decimal point.

Nullable

Clear this check box if the field value should not be null.

Default

Shows any default value that may be defined for this field.

Comment

Free text field. Enter any useful comment.

Note: Input metadata and output metadata are independent from each other. You can, for instance, change the label of a column on the output side without the column label of the input schema being changed.

However, any change made to the metadata are immediately reflected in the corresponding schema on the tMap relevant (Input or Output) area, but also on the schema defined for the component itself on the design workspace.

A Red colored background shows that an invalid character has been entered. Most special characters are prohibited in order for the Job to be able to interpret and use the text entered in the code. Authorized characters include lower-case, upper-case, figures except as start character.