Process multiple queries

The following example pipeline demonstrates how to process multiple Snowflake queries in a single transaction.


Mapper Snap Output

  1. Configure the Snowflake Execute Snap to define the user-defined function in the SQL statement. RECURSION_TEST is one of the Scalar JavaScript UDF in Snowflake. The Snap settings and the Output view are displayed as follows:
    Mapper Snap Output


    Mapper Snap Output
  2. Configure the Snowflake Multi Execute Snap as follows:
    Snowflake Multi Execute Settings
  3. The Snap settings and the Output view are displayed as follows:
    Snowflake Multi Execute Settings