Configuring Metadata of SQL statements manually

Sql statements that end with a semicolon(;) are auto parsed and the metadata is populated in the table field. If schema retrieval fails due to some reason, and the query is correct, then you can manually configure the metadata (by setting the Manually Configure Metadata option to true).

When Manually Configure Metadata is true, you can enter a simplified query in the text box and click Fetch .

Modifying Table Schema

When Manually Configure Metadata is set to true, the Table Schema is editable. You can modify the Table Schema by adding or deleting rows or changing the selections.

Note: When modifying the table schema ensure that the changes made are supported by valid SQL statement entered in the Textarea.
  1. Set Manually Configure Metadata to true.
  2. Make the modifications as required:
    • To modify table schema, add or delete rows as required and change the selections (by selecting or clearing check boxes).
      • The selected table fields are displayed on the Output tab of the activity.
      • The fields selected in the Parameter column are displayed on the Input tab of the activity.
    • To clear metadata information in the table, click Clear Table.
  3. Click Save.