User-Defined Functions

User-Defined Functions

Panoply supports user-defined functions (UDFs), which expand your ability to perform data manipulation when querying data.

You can create SQL-based UDFs or Python-based UDFs. You create UDFs through a workbench, including Panoply’s workbench or any external workbench. And you can use UDFs within any query.

For more information, see Creating User-Defined Functions in the Amazon Redshift Database Developer Guide.

For an explanation of why Python-based UDFs can be useful, see Introduction to Python UDFs in Amazon Redshift from the AWS Big Data Blog.