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

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

### In this section

* [Creating the Job](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/teltinput-teltmap-tsnowflakeinput-tlogrow-creating-job-a-new?id=2134)
* [Connecting to Snowflake](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/teltinput-teltmap-tsnowflakeinput-tlogrow-connecting-to-snowflake-standard-component?id=2135)
* [Configuring the input components](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/teltinput-teltmap-tsnowflakeinput-tlogrow-configuring-input-components?id=2136)
* [Configuring the output component](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/teltinput-teltmap-tsnowflakeinput-tlogrow-configuring-output-component?id=2137)
* [Configuring the map component for aggregating Snowflake data](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/teltinput-teltmap-tsnowflakeinput-tlogrow-configuring-map-component-for-aggregating-snowflake-data-click?id=2138)
* [Closing the Snowflake connection](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/teltinput-teltmap-tsnowflakeinput-tlogrow-closing-snowflake-connection?id=2139)
* [Executing the Job](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/teltinput-teltmap-tsnowflakeinput-tlogrow-executing-job-press?id=2140)

**Related concepts**

[tSnowflakeConnection](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/tsnowflakeconnection "Opens a connection to Snowflake that can then be reused by other Snowflake components.")

[tSnowflakeInput](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/tsnowflakeinput "Reads data from a Snowflake table into the data flow of your Job based on an SQL query.")

[tSnowflakeClose](https://help.qlik.com/talend/en-US/components/7.3/elt-hive/tsnowflakeclose "Closes an active Snowflake connection to release the occupied resources.")

**Related information**

[tELTInput](https://help.qlik.com/talend/r/en-US/7.3/components/elt-jdbc/teltinput)

[tELTMap](https://help.qlik.com/talend/r/en-US/7.3/components/elt-jdbc/teltmap)

[tELTOutput](https://help.qlik.com/talend/r/en-US/7.3/components/elt-jdbc/teltoutput)

[tLogRow](https://help.qlik.com/talend/r/en-US/7.3/components/logs-and-errors/tlogrow)