Query below return all User Defined Functions and information about it in Snowflake database.

Query

select function_schema,
       function_name,
       argument_signature as arguments,
       data_type as return_type,
       function_language,
       function_definition
from information_schema.functions
order by function_schema,
         function_name;

Columns

• function_schema, - name of the schema containing function
• function_name - name of the function
• arguments - function arguments type
• return_type - function return type
• function_language - language in which function is written
• function_definition - actual source code of the function for interpreted languages

Rows

• One row - represents one function
• Scope of rows: - all functions in database
• Ordered by - function schema, function name

Sample results