# tSnowflakeInput

Reads data from a Snowflake table into the data flow of your Job based on an SQL query.

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

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 [tSnowflakeInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/snowflake/tsnowflakeinput-standard-properties).

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

* Spark Batch: see [tSnowflakeInput properties for Apache Spark Batch (technical preview)](https://help.qlik.com/talend/en-US/components/7.3/snowflake/tsnowflakeinput-properties-for-apache-spark-batch-technical-preview).

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

### In this section

* [tSnowflakeInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/snowflake/tsnowflakeinput-standard-properties)
* [tSnowflakeInput properties for Apache Spark Batch (technical preview)](https://help.qlik.com/talend/en-US/components/7.3/snowflake/tsnowflakeinput-properties-for-apache-spark-batch-technical-preview)

**Related concepts**

[Writing data into and reading data from a Snowflake table](https://help.qlik.com/talend/en-US/components/7.3/snowflake/tsnowflakeconnection-tsnowflakerow-tsalesforceconnection-writing-data-into-and-reading-data-from-snowflake-table-standard-component "Here is an example of using Talend Snowflake components to connect to Snowflake, create a Snowflake table, write data into the table, then read data from this table, finally close the connection to Snowflake.")

[Aggregating Snowflake data using context variables as table and connection names](https://help.qlik.com/talend/en-US/components/7.3/snowflake/teltinput-teltmap-tsnowflakeinput-tlogrow-aggregating-snowflake-data-using-context-variables-as-table-and-connection-names "This scenario shows you an example of aggregating Snowflake data from two source tables STUDENT and TEACHER to one target table FULLINFO using the ELT components. In this example, set all input and output table names and connection names to context variables.")