organization_subscriptions

Description

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

Syntax

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

SELECT * FROM deltastream.sys."organization-subscriptions";
[{"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

Last updated