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

Column	Type	Nullable	Description
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:

SELECT * FROM deltastream.sys."function_sources";

[{"name":"functions","language":"java","status":"ready","description":"This is a udf from https://github.com/deltastreaminc/flink-udf-examples","download_url":"/v2/download/function_source/00000000-0000-0000-0000-000000000001/functions","owner":"sysadmin","created_by_role":"sysadmin","created_by_role_deleted":false,"created_by":"[e-mail]","created_at":"2025-11-14T12:28:05.471Z","updated_by_role":"sysadmin","updated_by_role_deleted":false,"updated_by":"[e-mail]","updated_at":"2025-11-14T12:28:05.471Z","organization_id":"00000000-0000-0000-0000-000000000001"}]

See Also

• System Tables Overview

• LIST FUNCTION_SOURCES

• CREATE FUNCTION_SOURCE