# Handling data with Redshift

This scenario describes a Job that writes the personal information into Redshift, then retrieves the information in Redshift and displays it on the console.

![](https://help.qlik.com/talend/en-US/components/8.0/Resources/images/components-use_case-tredshift-s1-job.png)

The scenario requires the following six components:

* tRedshiftConnection: opens a connection to Redshift.

* tFixedFlowInput: defines the personal information data structure, and sends the data to the next component.

* tRedshiftOutput: writes the data it receives from the preceding component into Redshift.

* tRedshiftInput: reads the data from Redshift.

* tLogRow: displays the data it receives from the preceding component on the console.

* tRedshiftClose: closes the connection to Redshift.

### In this section

* [Dropping and linking the components](https://help.qlik.com/talend/en-US/components/8.0/amazon-redshift/tredshiftconnection-tredshiftinput-tlogrow-dropping-and-linking-components-standard-component-drop)
* [Configuring the components](https://help.qlik.com/talend/en-US/components/8.0/amazon-redshift/tredshiftconnection-tredshiftinput-tlogrow-configuring-components-standard-component)
* [Saving and executing the Job](https://help.qlik.com/talend/en-US/components/8.0/amazon-redshift/tredshiftconnection-tredshiftinput-tlogrow-saving-and-executing-job-standard-component-press)

**Related concepts**

* [tRedshiftInput](https://help.qlik.com/talend/en-US/components/8.0/amazon-redshift/tredshiftinput "Reads data from a database and extracts fields based on a query so that you may apply changes to the extracted data.")
* [tRedshiftOutput](https://help.qlik.com/talend/en-US/components/8.0/amazon-redshift/tredshiftoutput "Writes, updates, modifies or deletes the data in a database.")

**Related reference**

* [tRedshiftConnection](https://help.qlik.com/talend/en-US/components/8.0/amazon-redshift/tredshiftconnection "Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.")
* [tRedshiftClose](https://help.qlik.com/talend/en-US/components/8.0/amazon-redshift/tredshiftclose "Closes the transaction committed in the connected DB.")

**Related information**

* [tFixedFlowInput](https://help.qlik.com/talend/en-US/components/8.0/tfixedflowinput/tfixedflowinput)
* [tLogRow](https://help.qlik.com/talend/en-US/components/8.0/logs-and-errors/tlogrow)