organizations

Description

Exposes basic metadata about the current organization. Each user sees only the organizations they are a member of. The messages field contains a JSON array of informational or warning messages issued by DeltaStream (e.g. billing or trial notices).

Note This table returns one row per organization the current user is a member of.

Syntax

SELECT ... FROM deltastream.sys."organizations";

Columns

Column	Type	Nullable	Description
id	VARCHAR	No	Unique identifier of the organization.
name	VARCHAR	No	Name of the organization.
messages	VARCHAR	No	JSON array of system messages associated with the organization (e.g. billing notices).

Examples

SELECT * FROM deltastream.sys."organizations";

[{"id":"00000000-0000-0000-0000-000000000001","name":"asdf","messages":"[]"}]

See Also

• System Tables Overview

• LIST ORGANIZATIONS