Aggregating Snowflake data using ELT components - Cloud - 8.0

ELT Hive

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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Talend Studio
ジョブデザインと開発 > サードパーティーシステム > ELTコンポーネント > ELT Hiveコンポーネント
データガバナンス > サードパーティーシステム > ELTコンポーネント > ELT Hiveコンポーネント
データクオリティとプレパレーション > サードパーティーシステム > ELTコンポーネント > ELT Hiveコンポーネント
Last publication date

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コンポーネント.

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.