User-Defined Function DDL

User-defined functions (UDFs) can be used to perform operations that are not available via the system-defined functions provided by Snowflake.


  • There are syntactical differences between executing a CREATE FUNCTION command in SnowSQL or the Worksheet (in the Snowflake web interface) and in sfsql:

    • sfsql requires a forward slash (/) after the command is executed to terminate the command.
    • SnowSQL and the Worksheet do not require a forward slash; in fact, including a forward slash will return an error.
  • DDL and DML operations are not supported in UDFs.