Support UDFs

User-defined functions (UDFs) created in the Snowflake console can be executed using Snowflake - Execute Snap. In the following example, the SQL statement is defined and then the Snap is executed with that 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