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

• System Tables Overview