TPT Update example

In this pipeline, the TPT Update Snap updates the values in the records of the TPT table using the upstream JSON Generator Snap. The error view is enabled for the invalid records to be routed to the error view.



  1. The JSON Generator Snap passes the values to be updated on the TPT table.


  2. The TPT Update Snap updates the records on the table, Insert Sample3 under the schema, ADW SNAPL.
  3. Note that the Where Columns are to be supplied with the condition(s) to check for the existing entries on the target table. The value for the column is supplied via the upstream JSON Generator Snap. In this example the primary key value is empno which is included in the Where columns as well as the Primary Partition columns fields of the Snap.


  4. The successful execution of the pipeline displays the below output preview:


To reuse the example pipelines:
  1. Download and import the SLP file into your Environment.
  2. Configure Snap accounts.
  3. Provide Pipeline parameters, if any.