Skip to main content Skip to complementary content

Retrieving data from the Teradata database table

Procedure

  1. Double-click tTeradataInput to open its Basic settings view.
  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.
  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.
  8. In the Mode area, select the Table (print values in cells of a table) option for a better display of the result.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!