Skip to main content Skip to complementary content

Defining dynamic schema columns

The dynamic schema columns are easy to define. To define dynamic columns for the Databases Input and Output components, or for tFileInputDelimited and tFileOutputDelimited.


  1. In the component's Basic settings tab, set the Property Type as Built-In.
    Information noteWarning: The dynamic schema is only supported in Built-In mode.
  2. Click Edit schema to define the schema.
    The Schema dialog box opens.
    Schema dialog box.
  3. In the last row added to the schema, enter a name for the dynamic column in the Column field.
    Information noteWarning: 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!