# organization\_subscriptions

## Description

Exposes the subscription plan details for the current organization. Requires USAGE privilege on the organization.

## Syntax

```sql
SELECT ... FROM deltastream.sys."organization-subscriptions";
```

## Columns

| Column            | Type           | Nullable | Description                                                         |
| ----------------- | -------------- | -------- | ------------------------------------------------------------------- |
| `organization_id` | VARCHAR        | No       | The unique identifier of the organization this resource belongs to. |
| `plan_name`       | VARCHAR        | No       | The subscription plan name for the organization.                    |
| `end_date`        | TIMESTAMP\_LTZ | No       | The date the current subscription ends.                             |
| `created_at`      | TIMESTAMP\_LTZ | No       | Timestamp when this resource was created.                           |
| `updated_at`      | TIMESTAMP\_LTZ | No       | Timestamp when this resource was last updated.                      |

## Examples

```sql
SELECT * FROM deltastream.sys."organization-subscriptions";
```

```sh
[{"organization_id":"00000000-0000-0000-0000-000000000001","plan_name":"deltastream","end_date":"2026-05-22T00:00:00Z","created_at":"2025-05-22T23:21:22.962Z","updated_at":"2025-08-27T01:18:27.957Z"}]
```

## See Also

* [System Tables Overview](https://docs.deltastream.io/reference/sql-syntax/systables)