Defining dynamic schema columns - 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 dynamic schema columns are easy to define. To define dynamic columns for the Databases Input and Output components, or for tFileInputDelimited and tFileOutputDelimited.

Procedure

  1. In the component's Basic settings tab, set the Property Type as Built-In.
    Warning: The dynamic schema is only supported in Built-In mode.
  2. Click Edit schema to define the schema.
    The Schema dialog box opens.
  3. In the last row added to the schema, enter a name for the dynamic column in the Column field.
    Warning: In the Database Input components, the SELECT query must include the * wildcard, to retrieve all of the columns from the table selected.
  4. Click the Type field and then the arrow which appears to select Dynamic from the list.