Skip to main content Skip to complementary content

Configuring the map component for aggregating Snowflake data

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!