Setting the file. One moment.
Skill 103 · Querying PostHog Data
Subchapter 103.42
references/models-early-access-features.mdMarkdown2 KBView on GitHub
Early access features let teams manage staged feature rollouts where users can opt in. Each feature is linked to a feature flag that controls access.
| Column | Type | Nullable | Description |
|---|---|---|---|
id | String | NOT NULL | Early access feature UUID. |
team_id | Integer | NOT NULL | |
feature_flag_id | Integer | NOT NULL | Feature flag gating the feature; joins to feature_flags.id. |
name | String | NOT NULL | Feature name shown to users. |
description | String | NOT NULL | Feature description shown to users. |
stage | String | NOT NULL | Lifecycle stage, e.g. ‘concept’, ‘beta’, ‘general-availability’. |
documentation_url | String | NOT NULL | Link to the feature’s documentation. |
created_by_id | Integer | NULL | User who created the feature. |
created_at | DateTime | NOT NULL | When the feature was created. |
Value | Description
draft | Initial stage, not visible to users
concept | Gauging interest, opt-in tracked but feature flag not enabled
alpha | Active stage, opted-in users get the feature flag enabled
beta | Active stage, opted-in users get the feature flag enabled
general-availability | Active stage, feature available to all users
archived | Feature retired, flag enrollment conditions removed
Active stages (where opted-in users get the feature flag enabled): alpha, beta, general-availability.
feature_flag_id -> system.feature_flags.idstage field uses a hyphenated value general-availability (not underscore).feature_flag_id are rare but possible during creation errors.List all early access features with their stages:
SELECT id, name, stage, feature_flag_id, created_at
FROM system.early_access_features
ORDER BY created_at DESC
LIMIT 100Find active features (in alpha, beta, or GA):
SELECT id, name, stage, feature_flag_id
FROM system.early_access_features
WHERE stage IN ('alpha', 'beta', 'general-availability')
ORDER BY created_at DESCJoin with feature flags to see flag keys:
SELECT eaf.id, eaf.name, eaf.stage, ff.key AS flag_key
FROM system.early_access_features AS eaf
LEFT JOIN system.feature_flags AS ff ON eaf.feature_flag_id = ff.id
ORDER BY eaf.created_at DESC
LIMIT 100