Integrations
PostHog datasets and fields
The 17 datasets Maven lands from PostHog, every field in them, and how the connection syncs.
Maven lands 17 datasets from PostHog in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the PostHog integration page.
Connection and sync#
You connect PostHog with API credentials from the PostHog account. Maven stores them encrypted.
Each PostHog sync takes a fresh copy of the current records, so the workspace always reflects what is in PostHog now.
Datasets#
Integration sources#
Configured existing warehouse mapping for canonical PostHog datasets.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| mode | Text |
| source type | Text |
| warehouse type | Text |
| database | Text |
| schema | Text |
| dataset | Text |
| dataset category | Text |
| table ref | Text |
| is required | True/false |
| status | Text |
| validation issue | Text |
| required fields | Text |
| optional fields | Text |
| description | Text |
Events#
Canonical UUID-deduplicated PostHog Batch Export events.
| Field | Type |
|---|---|
| uuid | Text |
| event | Text |
| timestamp | Timestamp |
| distinct ID | Text |
| team ID | Integer |
| properties | JSON |
| elements | JSON |
| set | JSON |
| set once | JSON |
| bq ingested at | Timestamp |
| integration ID | Text |
Person distinct IDs#
PostHog person-to-distinct-id identity bridge.
| Field | Type |
|---|---|
| person ID | Text |
| distinct ID | Text |
| version | Integer |
| created at | Timestamp |
| integration ID | Text |
Groups#
PostHog group analytics entities and current group properties.
| Field | Type |
|---|---|
| group type index | Integer |
| group key | Text |
| group properties | JSON |
| created at | Timestamp |
| updated at | Timestamp |
| integration ID | Text |
Sessions#
PostHog session rollups when included in the warehouse export.
| Field | Type |
|---|---|
| session ID | Text |
| distinct ID | Text |
| start timestamp | Timestamp |
| end timestamp | Timestamp |
| duration s | Number |
| pageview count | Integer |
| autocapture count | Integer |
| integration ID | Text |
Persons#
| Field | Type |
|---|---|
| team ID | Integer |
| distinct ID | Text |
| person ID | Text |
| properties | JSON |
| person version | Integer |
| person distinct ID version | Integer |
| created at | Timestamp |
| integration ID | Text |
Feature flags#
PostHog feature flag metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Experiments#
PostHog experiment metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Surveys#
PostHog survey metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Cohorts#
PostHog cohort metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Actions#
PostHog action metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Insights#
PostHog saved insight metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Dashboards#
PostHog dashboard metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Annotations#
PostHog annotation metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Event definitions#
PostHog event definition metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Property definitions#
PostHog property definition metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| stream | Text |
| posthog ID | Text |
| key | Text |
| name | Text |
| type | Text |
| status | Text |
| is active | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| deleted | True/false |
Batch exports#
PostHog Batch Export configuration/status metadata.
| Field | Type |
|---|---|
| integration ID | Text |
| project ID | Text |
| environment ID | Text |
| batch export ID | Text |
| name | Text |
| destination type | Text |
| interval | Text |
| paused | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| last run at | Timestamp |