UDF - User Defined Functions

Typically calculate and return a value.

Supported  Languages:

• SQL
• Python
• Java
• Javascript

Scalar functions: Returns one output row per input row

Tabular functions: Returns a tabular value for each row

        

Function is a securable-schema level object 

 

General syntax for function:

CREATE FUNCTION (n int)

returns int

AS

$$

n+2;

$$;