Support UDFs

This example pipeline demonstrates how to execute user-defined functions (UDFs) created in the Snowflake console using the Snowflake - Execute Snap by defining the SQL statement and running the Snap with the specified conditions.


Snowflake Execute pipeline

  1. First, the Snowflake Execute Snap is used to give the user-defined SQL statement area_of_circle(3.0) is a UDF here. The Snap settings and the output view are as follows:
    Snowflake Execute Output
  2. Then the Mapper Snap is used to define columns that need to be picked up from the Output of the Snowflake Execute.
    Mapper Snap


    Mapper Snap Output