Retrieving the data from Redshift - Cloud - 8.0

Amazon Redshift
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 > Amazon services (Integration) > Amazon Redshift components
Data Quality and Preparation > Third-party systems > Amazon services (Integration) > Amazon Redshift components
Design and Development > Third-party systems > Amazon services (Integration) > Amazon Redshift components
Last publication date
2024-02-20

Procedure

  1. Double-click tRedshiftInput to open its Basic settings view.
  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.