# Retrieving the data from Redshift

## Procedure

1. Double-click tRedshiftInput to open its Basic settings view.

   ![](https://help.qlik.com/talend/en-US/components/8.0/Resources/images/components-use_case-tredshift-s1-tredshiftinput.png)
2. Select the Use an existing connection check box, and then select the connection you have already configured for tRedshiftConnection from the Component List drop-down list.
3. Click the [...] button next to Edit schema to open the schema editor.
4. In the schema editor, click the [+] button to add three columns: *id* of the interger type, *name* of the string type, and *age* of the integer type. The data structure is same as the structure you have defined for tFixedFlowInput.
5. Click OK to validate the changes and accept the propagation prompted by the pop-up [Propagate] dialog box.
6. In the Table Name field, enter or browse to the table into which you write the data, *redshiftexample* in this scenario.
7. Click the Guess Query button to generate the query. The Query field will be filled with the automatically generated query.