Procedure
-
Double-click tRedshiftInput to open its
Basic settings view on the Component tab.
- Fill the Host, Port, Database, Schema, Username, and Password fields with their corresponding context variables.
- In the Table Name field, enter the name of the table to be read. In this example, it is person.
- Click the [...] button next to Edit schema and in the pop-up window define the schema by adding two columns: ID of Integer type and Name of String type.
-
In the Query field, enter the following
SQL statement based on which the data are retrieved.
"SELECT * FROM" + context.redshift_schema + "person ORDER BY \"ID\""
-
Double-click tLogRow to open its
Basic settings view on the Component tab.
- In the Mode area, select Table (print values in cells of a table) for a better display of the result.