I can share my project, a set of AWS Lambda based user defined functions (UDF) that allow one to do direct/reverse geocoding using SQL statements, delegating this task to the newly released Amazon Location Service. Check it out on:
https://github.com/aws-samples/amazon-redshift-location-user-defined-functions.
The project contain all the source code to setup the UDFs, the IAM roles, the AWS Lambdas in a CloudFormation template. You can even Launch it in your account clicking on the "Lauch Stack" button.
It's a completely functional sample, please check.
Answer from Fabio Oliveira on Stack OverflowAWS
docs.aws.amazon.com › amazon redshift › database developer guide › user-defined functions in amazon redshift
User-defined functions in Amazon Redshift - Amazon Redshift
You can create a custom scalar user-defined function (UDF) using either a SQL SELECT clause or a Python program. The new function is stored in the database and is available for any user with sufficient privileges to run. You run a custom scalar UDF in much the same way as you run existing Amazon ...
Reddit
reddit.com › r/aws › user defined functions in separate schema in redshift
r/aws on Reddit: User Defined Functions In Separate Schema in REDSHIFT
September 13, 2022 -
Is it possible to create user defined functions in redshift in a separate schema ? If so, how?
Thank you!!
Videos
22:12
AWS Redshift User Defined Functions - YouTube
33:12
Overview of Redshift and User Defined Function - YouTube
24:26
AWS Tutorials - Using Lambda UDF with Amazon Redshift - YouTube
#20 User Defined functions in Redshift - YouTube
14:03
Introducing User Defined Functions (UDFs) in Amazon Athena - YouTube
Dwgeek
dwgeek.com › home › redshift user defined functions examples
Redshift User Defined Functions Examples - DWgeek.com
February 22, 2023 - Above example demonstrate how to create user defined function and call it using SQL statement. The SELECT clause can’t include any of the following types of clauses in the statements: ... You can create the UDFs by calling other UDFs. Redshift does not track the dependency while creating UDF.
AWS
docs.aws.amazon.com › amazon redshift › database developer guide › sql reference › sql commands › create function
CREATE FUNCTION - Amazon Redshift
Amazon Redshift will no longer ... until June 30, 2026. For more information, see the blog post ... Creates a new scalar user-defined function (UDF) using either a SQL SELECT clause or a Python program....
Erwin
bookshelf.erwin.com › bookshelf › public_html › 12.0 › Content › User Guides › erwin Help › Defining_Redshift_Functions.html
Defining Redshift Functions
The following properties are applicable to a Redshift Function object.
Aws-news
aws-news.com › article › 2025-06-30-amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026
Amazon Redshift Python user-defined functions will reach end of support after June 30, 2026
June 30, 2025 - Amazon Redshift will end support for Python user-defined functions (UDFs) after June 30, 2026, recommending migration to more flexible and scalable Lambda ...
Medium
medium.com › wunderlist-engineering › amazon-redshift-s-udf-b3d4205ae732
Amazon Redshift’s UDF
October 22, 2015 - Amazon Redshift’s UDF As you have probably heard, Amazon released User Defined Functions for Amazon Redshift and now you can write your own stored procedures in Python. I, myself, was looking …
GitHub
github.com › aws-samples › amazon-redshift-udfs
GitHub - aws-samples/amazon-redshift-udfs: A collection of example UDFs for Amazon Redshift. · GitHub
A collection of stored procedures and user-defined functions (UDFs) for Amazon Redshift.
Starred by 244 users
Forked by 73 users
Languages PLpgSQL 87.6% | Shell 10.9%
AWS
docs.aws.amazon.com › amazon redshift › database developer guide › user-defined functions in amazon redshift › use case examples for user-defined functions (udfs)
Use case examples for user-defined functions (UDFs) - Amazon Redshift
Existing Python UDFs will continue to function until June 30, 2026. Starting July 1, 2026, Amazon Redshift will no longer support Python UDFs. We recommend that you migrate your existing Python UDFs to Lambda UDFs before November 1, 2025. For information on creating and using Lambda UDFs, see Scalar Lambda UDFs. For information on converting existing Python UDFs to Lambda UDFs, see the blog post ... You can use user-defined ...
BMC Software
bmc.com › blogs › amazon-redshift-udf-python
Creating Redshift User Defined Function (UDF) in Python – BMC Software | Blogs
November 3, 2020 - You can create user defined functions in Amazon Redshift in Python. If you use Amazon Lambda containerless virtual machines, then you can use additional languages. (Using AWS Lambda, you will have some usage costs.
Databricks
docs.databricks.com › user-defined functions (udfs)
What are user-defined functions (UDFs)? | Databricks on AWS
1 week ago - User-defined functions (UDFs) allow you to reuse and share code that extends built-in functionality on Databricks.
Trevor Fox
trevorfox.com › 2020 › 02 › intro-to-sql-udfs-in-redshift
Intro to SQL User-Defined Functions: A Redshift UDF Tutorial • Trevor Fox
March 19, 2023 - This is Redshift’s example from their docs. It takes two parameters (both specified as float) and returns the value that is greater of the two. create function f_sql_greater (float, float) returns float stable as $$ select case when $1 > $2 then $1 else $2 end $$ language sql; To refer to the different parameters in the function, you just use the dollar sign ($) and the order of the parameter in the function definition.
X
x.com › awscloud › status › 642380423356518400
Amazon Redshift now supports Scalar User-Defined ...
We’ve detected that JavaScript is disabled in this browser. Please enable JavaScript or switch to a supported browser to continue using x.com. You can see a list of supported browsers in our Help Center · AWS is the world's most comprehensive cloud, enabling organizations to accelerate ...
GitHub
github.com › aws-samples › amazon-redshift-location-user-defined-functions
GitHub - aws-samples/amazon-redshift-location-user-defined-functions: Amazon Redshift User Defined Functions to call Amazon Location Service APIs
This repository contain the code necessary to deploy Amazon Redshift Lambda-based User Defined Functions (UDF) to allow a user to call Amazon Location Service APIs, such as geocoding and reverse geocoding, as part of SQL queries.
Starred by 8 users
Forked by 4 users
Languages Python 100.0% | Python 100.0%
InterviewBit
interviewbit.com › sql-interview-questions
SQL Interview Questions CHEAT SHEET (2026) - InterviewBit
The user-defined functions in SQL are like functions in any other programming language that accept parameters, perform complex calculations, and return a value. They are written to use the logic repetitively whenever required.
Published March 24, 2026
AWS
docs.aws.amazon.com › amazon redshift › database developer guide › user-defined functions in amazon redshift › scalar sql udfs
Scalar SQL UDFs - Amazon Redshift
Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025. If you would like to use Python UDFs, create the UDFs prior to that date. Existing Python UDFs will continue to function as normal. For more information, see the blog post ... A scalar SQL UDF incorporates a SQL SELECT clause that runs when the function is called and returns a single value. The CREATE FUNCTION command defines ...
AWS re:Post
repost.aws › articles › ARAG0AgN80SjyvzTH0Ngfjbg › speed-up-redshift-udf-development-and-share-useful-code
Speed up Redshift UDF Development and share useful code | AWS re:Post
January 18, 2023 - The following repository helps you create different types of functions and supplies a repository of community developed functions you can easily deploy to your Redshift environment. There are many options (python, sql, lambda) to create scalar ...
AWS bytes
awsbytes.com › how-to-get-the-list-of-all-user-defined-functions-in-redshift-database
How to get the list of all User Defined Functions in Redshift database – AWS bytes
January 19, 2022 - You can query the pg_proc_info system catalog view to list all the user defined functions in a redshift database. pg_proc_info view has information on all functions and stored procedures. prokind c…