August 15, 2023

Retrieving the data from Redshift – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Retrieving the data from Redshift – Docs for ESB 6.x

Retrieving the data from Redshift

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

    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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x