August 15, 2023

Configuring the map component for aggregating Snowflake data – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the map component for aggregating Snowflake data – Docs for ESB 6.x

Configuring the map component for aggregating Snowflake data

  1. Click the tELTJDBCMap component to open its
    Basic settings view.

    elt_snowflake_using_variables_teltjdbcmap_basic_settings.png

  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 JDBC 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 tELTJDBCOutput
    component to set its schema.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x