# 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.

### In this section

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

**Related concepts**

* [Handling data with Redshift](https://help.qlik.com/talend/en-US/components/8.0/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/8.0/amazon-redshift/tredshiftinput-tredshiftbulkexec-ts3get-loading-unloading-data-to-from-amazon-s3-standard-component-this)