organization_defaults

Description

Exposes the session defaults configured for the current user in this organization. Each user sees only their own defaults row. Use SET DEFAULT to change these values.

Syntax

SELECT * FROM deltastream.sys."organization_defaults";

Columns

Column	Type	Nullable	Description
id	VARCHAR	No	Unique identifier of the organization membership record (matches the caller's org_member_id).
organization_id	VARCHAR	No	The unique identifier of the organization this resource belongs to.
default_role	VARCHAR	No	The default role for the current user's session.
default_database	VARCHAR	Yes	The default database for the current user's session.
default_store	VARCHAR	Yes	The default store for the current user's session.
default_compute_pool	VARCHAR	Yes	The default compute pool for the current user's session.

Examples

$ dsql -e 'SELECT * FROM deltastream.sys."organization_defaults";'
[{"id":"00000000-0000-0000-0000-000000000002","organization_id":"00000000-0000-0000-0000-000000000001","default_role":"sysadmin","default_database":"mydb","default_store":"mystore","default_compute_pool":"mycp2"}]

See Also

• System Tables Overview

• SET DEFAULT