Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
titleELT Join Snap requires an account configuration

Starting from 4.24 GA, ensure to configure an account for this Snap.

Prerequisites

None.

Limitations

...

Limitation

Multiexcerpt include macro
nameME_ELT_GBQ_StandardSQL_UOI
pageELT Copy

Known Issues

Multiexcerpt include macro
nameME_ELT_KI_Underscore_Refs
pageELT Snap Pack

...

First we use two ELT Select Snaps to retrieve data from the SF store and SF date_dim tables respectively. We configure the ELT Select Snaps as shown below; the respective output views are as shown below.

ELT Select SnapsOutput

Image Modified

Image Modified

Image Modified

Image Modified

Then, we configure the ELT Filter Snaps with the following filter conditions.

ELT Filter SnapsOutput

Filter condition: "SR_ITEM_SK">=120000

Image Modified

Filters the records by SR_ITEM_SK column whose values are greater than or equal to 120000.

Image Modified

Filter condition: "D_YEAR">=2000

Image Modified

Filters the records by year greater than or equal to 2000.

Image Modified

Then, we configure the ELT Join Snap to perform a left outer join based on the matching values of the D_DATE_SK column in both the tables by applying a Join condition. Note that we select Only Duplicate Columns for Resultant Column Names Prefix Type to avoid collision of identical columns in the resultant output.

...