System Tables

System tables are read-only relations in the deltastream.sys virtual schema that expose metadata about your DeltaStream organization. They can be queried using standard SQL SELECT statements, which makes them useful for programmatic access, automation, and agents that need to inspect or reason about the state of your DeltaStream resources.

Syntax

SELECT column [, ...]
FROM deltastream.sys."<table_name>"
[ WHERE condition ]
[ ORDER BY column ]
[ LIMIT n ];

Description

System tables provide the same information as the corresponding LIST and DESCRIBE commands, but as queryable SQL relations. This allows you to filter, sort, join, and aggregate metadata in ways that the dedicated commands do not support.

Note System table names must be quoted with double quotes, e.g. deltastream.sys."compute_pools".

Access Control

Each system table enforces role-based access control automatically. Rows are filtered to only those resources the current role has USAGE privileges on. No additional WHERE clause is needed to scope results to the current role.

Column Types

Columns in system tables use the following DeltaStream types:

PostgreSQL type	DeltaStream type
boolean	BOOLEAN
smallint	SMALLINT
integer	INTEGER
bigint	BIGINT
varchar, text, uuid	VARCHAR
timestamptz	TIMESTAMP_LTZ

Available System Tables

Table	Description
audit_logs	Audit log of all actions performed in the organization
compute_pools	Compute pools defined in the organization
databases	Databases in the organization
descriptor_sources	Protobuf descriptor sources
function_sources	Function source packages (JARs)
functions	User-defined functions (UDFs)
organization_defaults	Per-user session defaults (role, database, store, compute pool)
organization_subscriptions	Subscription plan details for the organization
organizations	Organizations the current user is a member of
pgusers	PostgreSQL-compatible user credentials
queries	Streaming queries (active and historical)
query_tags	Key/value tags attached to queries
relation_columns	Column definitions for all relations
relations	Streams, changelogs, tables, materialized views, and indexes
role_privileges	Privilege grants for roles
roles	Roles defined in the organization
schema_registries	Schema registry connections
schemas	Schemas (namespaces) within databases
secrets	Secrets (metadata only, values never exposed)
stores	External system connections
user_grants	User-to-role membership grants
userdatas	Per-user key/value metadata (internal UI state)