# 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

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

```sh
$ 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](https://docs.deltastream.io/reference/sql-syntax/systables)
* [SET DEFAULT](https://docs.deltastream.io/reference/sql-syntax/command/set-default)