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 for 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, Table Schema is editable. You can modify Table Schema by adding or deleting rows or by changing the selections.

When modifying Table Schema ensure that the changes made are supported by a valid SQL statement entered in the text area under the Query field.

Procedure
1. Set Manually Configure Metadata to true.
2. Make the required modifications:

   • To modify Table Schema, add or delete rows as required and change the selections (by selecting or clearing checkboxes).

     • 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.

     • Select the Value checkbox to use the input fields under Values[] node as a part of values clause.

   • To clear metadata information in the table, click Clear Table.

3. Click Save.