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