function_sources
Description
Exposes metadata about function sources (JAR packages containing UDF implementations) in the organization. Only function sources on which the current role has USAGE privileges are returned.
Syntax
SELECT * FROM deltastream.sys."function_sources";Columns
name
VARCHAR
No
Name of the function source.
language
VARCHAR
No
Programming language of the function source. Currently java.
status
VARCHAR
No
Upload status of the function source. One of ready, error.
description
VARCHAR
Yes
Optional description of the function source.
download_url
VARCHAR
No
Internal URL to download the function source artifact.
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 function sources:
See Also
Last updated