# tRedshiftInput

Reads data from a database and extracts fields based on a query so that you may apply changes to the extracted data.

tRedshiftInput executes a DB query with a strictly defined order which must correspond to the schema definition. Then it passes on the field list to the next component through a Main row link.

For more technologies supported by Talend, see [Talend components](https://help.qlik.com/talend/r/en-US/7.3/components/amazon-redshift).

Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks:

* Standard: see [tRedshiftInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/amazon-redshift/tredshiftinput-standard-properties).

  The component in this framework is available in all Talend products.

* Spark Batch: see [tRedshiftInput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/amazon-redshift/tredshiftinput-properties-for-apache-spark-batch).

  The component in this framework is available in all Talend products with Big Data and Talend Data Fabric.

### In this section

* [tRedshiftInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/amazon-redshift/tredshiftinput-standard-properties)
* [tRedshiftInput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/amazon-redshift/tredshiftinput-properties-for-apache-spark-batch)

**Related concepts**

[Handling data with Redshift](https://help.qlik.com/talend/en-US/components/7.3/amazon-redshift/tredshiftconnection-tredshiftinput-tlogrow-handling-data-with-redshift-standard-component-this)

[Loading/unloading data to/from Amazon S3](https://help.qlik.com/talend/en-US/components/7.3/amazon-redshift/tredshiftinput-tredshiftbulkexec-ts3get-loading-unloading-data-to-from-amazon-s3-standard-component-this)