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 the Manually Configure Metadata option is set to true, you can enter a simplified query in the text box and click Fetch. Corresponding columns from the database table are added in the table schema.

Modifying Table Schema

When the Manually Configure Metadata option is set to true, the Table Schema is editable. You can modify the Table Schema by adding or deleting rows or by changing the selections. Also, you can clear metadata information in the table by clicking Clear Table.

Note: When modifying the table schema, ensure that the changes made are supported by a valid SQL statement entered in the Text area.

  1. Set Manually Configure Metadata to true.
  2. You can make the following modifications per your requirements:
    • To modify table schema, add or delete rows as required and change the selections (by selecting or clearing checkboxes).
      • The fields whose Selected column is checked, are displayed on the Output tab of the activity.
      • The fields whose Parameter and Value columns are checked, are displayed on the Input tab of the activity.

  3. Click Save.