Configuring the map component for aggregating Snowflake data - 7.1

ELT Vertica

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
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 Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > ELT components > ELT Vertica components
Data Quality and Preparation > Third-party systems > ELT components > ELT Vertica components
Design and Development > Third-party systems > ELT components > ELT Vertica components
EnrichPlatform
Talend Studio

Procedure

  1. Click the tELTMap component to open its Basic settings view.
  2. Select the Use an existing connection check box and from the Component List displayed, select the connection component you have configured to open the Snowflake connection.
  3. Select Mapping Snowflake from the Mapping drop-down list.
  4. Click the [...] button next to ELT Map Editor to open its map editor.
  5. Add the first input table context.SourceTableS by clicking the [+] button in the upper left corner of the map editor and then selecting the relevant table name from the drop-down list in the pop-up dialog box.
  6. Do the same to add the second input table context.SourceTableT.
  7. Drag the column TID from the first input table context.SourceTableS and drop it onto the corresponding column TID in the second input table context.SourceTableT.
  8. Drag all columns from the input table context.SourceTableS and drop them onto the output table context.TargetTable in the upper right panel.
  9. Do the same to drag two columns TNAME and TPHONE from the input table context.SourceTableT and drop them onto the bottom of the output table. When done, click OK to close the map editor.
  10. Click the Sync columns button on the Basic settings view of the tELTOutput component to set its schema.