functions
Description
Exposes metadata about user-defined functions (UDFs) registered in the organization. Only functions on which the current role has USAGE privileges are returned.
Syntax
SELECT * FROM deltastream.sys."functions";Columns
name
VARCHAR
No
Name of the function.
signature
VARCHAR
No
Full function signature including parameter types, e.g. myfunc(VARCHAR).
class_name
VARCHAR
No
Fully qualified Java class name implementing the function.
type
VARCHAR
No
Function type. Currently udf.
language
VARCHAR
No
Implementation language. Currently java.
function_source_name
VARCHAR
No
Name of the function source that contains the function implementation.
owner
VARCHAR
No
The role that owns this resource.
created_by_role
VARCHAR
No
The role that created this resource.
created_by_role_deleted
BOOLEAN
No
Whether the creating role has since been deleted.
created_by
VARCHAR
No
The user that created this resource.
created_at
TIMESTAMP_LTZ
No
Timestamp when this resource was created.
updated_by_role
VARCHAR
No
The role that last updated this resource.
updated_by_role_deleted
BOOLEAN
No
Whether the last updating role has since been deleted.
updated_by
VARCHAR
No
The user that last updated this resource.
updated_at
TIMESTAMP_LTZ
No
Timestamp when this resource was last updated.
organization_id
VARCHAR
No
The unique identifier of the organization this resource belongs to.
Examples
List all user-defined functions:
See Also
Last updated