# PostHog datasets and fields

> The 17 datasets Maven lands from PostHog, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/posthog

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](https://mavendata.ai/integrations/posthog).

## 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 |
