SET SESSION UDFSEARCHPATH SQL Statement | VantageCloud Lake - SET SESSION UDFSEARCHPATH - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

Allows you to specify a custom UDF search path. When you run a UDF, Vantage searches this path first, before looking in the default Vantage search path for the UDF.

If you have created your own UDF that has the same name as a Vantage system UDF, you can use this statement to make sure Vantage runs your UDF, rather than the Vantage system UDF.

ANSI Compliance

SET SESSION UDFSEARCHPATH is ANSI-2011 SQL-compliant with extensions.

Required Privileges

You must have access to any database you specify as part of the UDF search path.