# 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.

{% hint style="info" %}
**Note** This table contains internal UI state stored by the DeltaStream web application. Its contents are subject to change without notice.
{% endhint %}

## Syntax

```sql
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

```sh
$ 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](https://docs.deltastream.io/reference/sql-syntax/systables)