userdatas

Description

Exposes per-user key/value metadata stored by the DeltaStream platform (e.g. UI state, preferences). Each user sees only their own data. This table is primarily used internally by the DeltaStream web application.

Note This table contains internal UI state stored by the DeltaStream web application. Its contents are subject to change without notice.

Syntax

SELECT * FROM deltastream.sys."userdatas";

Columns

Column	Type	Nullable	Description
org_member_id	VARCHAR	No	Unique identifier of the organization membership record this data belongs to.
key	VARCHAR	No	Key name of the user data entry.
value	VARCHAR	No	Value of the user data entry.
created_at	TIMESTAMP_LTZ	No	Timestamp when this entry was created.
updated_at	TIMESTAMP_LTZ	No	Timestamp when this entry was last updated.
organization_id	VARCHAR	No	The unique identifier of the organization this resource belongs to.

Examples

$ dsql -e 'SELECT * FROM deltastream.sys."userdatas";'
[{"org_member_id":"00000000-0000-0000-0000-000000000002","key":"trialModalState","value":"hidden","created_at":"2025-05-22T23:21:33.729Z","updated_at":"2025-05-22T23:21:33.729Z","organization_id":"00000000-0000-0000-0000-000000000001"}]

See Also

• System Tables Overview