# Retrieving data from the Teradata database table

## Procedure

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

   ![](https://help.qlik.com/talend/en-US/components/7.2/Resources/images/components-tteradatatptexec_s1_tteradatainput.png)
2. In the Table Name field, enter the name of the table to read data from. In this example, it is *person*.
3. In the Query field, enter the following SQL statement to retrieve data from the table *person*.
   ```
   SELECT * FROM samples.person ORDER BY id
   ```
4. Click the [...] button next to Edit schema to open the schema editor.

   ![](https://help.qlik.com/talend/en-US/components/7.2/Resources/images/components-tteradatatptexec_s1_tteradatainput_schema.png)
5. Click the [+] button to add three columns: *id* of the integer type, *name* and *sex* of the string type. Note that *id* and *name* in Db Column are enclosed in a pair of *\"* since they are Teradata database keywords.
6. Click OK to close the schema editor and accept the propagation prompted by the pop-up dialog box.
7. Double-click tLogRow to open its Basic settings view.

   ![](https://help.qlik.com/talend/en-US/components/7.2/Resources/images/components-tteradatatptexec_s1_tlogrow.png)
8. In the Mode area, select the Table (print values in cells of a table) option for a better display of the result.