List user defined functions (UDFs) in Snowflake

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

0
There are no comments. Click here to write the first comment.