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
Last updated