Schematic
This source is currently in alpha. The interface and available tables may change.
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Schematic to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Sync your Schematic companies, users, features, flags, plans, entitlements and billing catalog into the PostHog Data warehouse.
Use a secret API key for the environment you want to sync, created under Settings > API keys in Schematic. Publishable keys can't list data.
Configuration
| Option | Type | Required |
|---|---|---|
Secret API key | password | Yes |
Linking Schematic to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Schematic
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
companies | A customer account in Schematic, with its lookup keys, traits, assigned plans and billing subscription. | Full refresh | — | — |
users | An end user tracked by Schematic, with its lookup keys, traits and company memberships. | Full refresh | — | — |
company_memberships | A link between a user and a company. | Full refresh | — | — |
features | A feature defined in Schematic that plans and companies can be entitled to. | Full refresh | — | — |
flags | A feature flag evaluated by the Schematic SDKs. | Full refresh | — | — |
plans | A plan or add-on that bundles feature entitlements and billing products. | Full refresh | — | — |
plan_entitlements | A feature entitlement granted by a plan, with its limit and metering period. | Full refresh | — | — |
company_overrides | A per-company entitlement override that replaces the plan entitlement for one feature. | Full refresh | — | — |
billing_customers | A customer synced from the billing provider, with its subscriptions. | Full refresh | — | — |
billing_products | A product synced from the billing provider. | Full refresh | — | — |
billing_prices | A price synced from the billing provider. | Full refresh | — | — |
billing_coupons | A coupon synced from the billing provider. | Full refresh | — | — |
billing_meters | A usage meter synced from the billing provider. | Full refresh | — | — |