descriptor_sources

Description

Exposes metadata about descriptor sources (Protobuf schema registries) in the organization. Descriptor sources hold .proto descriptor files used for deserializing Protobuf-encoded data. Only descriptor sources on which the current role has USAGE privileges are returned.

Syntax

SELECT ... FROM deltastream.sys."descriptor-sources";

Columns

Column	Type	Nullable	Description
name	VARCHAR	No	Name of the descriptor source.
type	VARCHAR	No	Type of the descriptor source. Currently protobuf.
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

SELECT * FROM deltastream.sys."descriptor-sources";

[{"name":"pageviews_key","type":"protobuf","owner":"sysadmin","created_by_role":"sysadmin","created_by_role_deleted":false,"created_by":"[email protected]","created_at":"2025-06-16T20:39:02.453Z","updated_by_role":"sysadmin","updated_by_role_deleted":false,"updated_by":"[email protected]","updated_at":"2025-06-16T20:39:02.453Z","organization_id":"00000000-0000-0000-0000-000000000001"}]

See Also

• System Tables Overview

• LIST DESCRIPTOR_SOURCES

• CREATE DESCRIPTOR_SOURCE