Aggregating Snowflake data using ELT components - Cloud - 8.0

Snowflake

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Cloud storages > Snowflake components
Data Quality and Preparation > Third-party systems > Cloud storages > Snowflake components
Design and Development > Third-party systems > Cloud storages > Snowflake components
Last publication date
2024-03-21

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.

For more technologies supported by Talend, see Talend components.

The ELT components, that is, tELTInput, tELTMap, and the tELTOutput components, are closely related. They work jointly to generate SQL statements from database tables. The SQL statement is then executed by the tELTOutput component to perform specified actions to a specific database table. The Job in this scenario shows a common way in which the ELT components are connected to generate SQL statements from multiple database tables. The following list describes the functions of the components.
  • tELTInput specifies input database table and schema. You can use multiple database tables as the input by connecting multiple tELTInput components to a tELTMap component and specifying a database table for each of the tELTInput components.
  • tELTMap defines how the schema columns of the input database tables are mapped to the output columns. This component also allows you to set the mapping conditions.
  • tELTOutput generates the SQL statement according to the mapping relationship defined in tELTMap and the actions (including action on table and action on data). The SQL statement is stored in the Query variable of the tELTOutput component.

In this example, context variables are used to hold all the input and output table names and connection names.