Look up object record

The following example shows how a Snowflake object record can be looked up using the Snowflake Lookup Snap and record the data using the Snowflake Execute Snap.

In this pipeline, the Snowflake Execute Snap writes the data from the Snowflake table ADOBEDATA123 to the target Snowflake table, ADOBEDATA using the Snowflake Lookup Snap.


Mapper Snap Output

  1. The Execute Snap runs the select query to retrieve the data from the table ADOBEDATA123.
    Mapper Snap Output
  2. The Snowflake Lookup Snap runs the lookup query on, and the lookup conditions specify the column names to be looked up in the look-up table ADOBEDATA123.
    Additionally, in the Output fields, select the names of the specific output field name(s) for the output preview to contain only those fields("ACCOUNT_C", "ADOBE_ROLE_C", "ID") to be recorded on the target table, ADOBEDATA.

    Mapper Snap Output

  3. Successful execution of the Snap gives the following preview:

    Mapper Snap Output

    Note: Note that the output preview has only those column names that were specified in the output fields. The column, original, displays all the column names present in the original table (ADOBEDATA123) as displayed below:

    Mapper Snap Output