Retrieving data from the Teradata database table - Cloud - 8.0

Teradata
Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database components (Integration) > Teradata components
Data Quality and Preparation > Third-party systems > Database components (Integration) > Teradata components
Design and Development > Third-party systems > Database components (Integration) > Teradata components
Last publication date
2024-02-20

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.