Amazon Redshift Introduces SQL Scalar User-Defined Functions

You can now create and run scalar user-defined functions (UDFs) using SQL in Amazon Redshift.

Using PostgreSQL syntax, you can create custom SQL scalar functions and execute them in parallel across your clusters. For faster performance, we replace the SQL function name with the SQL function code on the leader node, and these are then run as regular SQL in parallel on each node of your cluster. Once defined, you can call these scalar UDFs in any SQL statement.

To learn more about creating and using scalar UDFs, see the scalar UDF documentation.

SQL scalar user-defined functions are now available in all regions.