Models Batch Exports · Querying PostHog Data · PostHog/skills · Skills Docs

Models Batch Exports · Querying PostHog Data · PostHog/skills · Skills Docs

Column	Type	Nullable	Description
`id`	uuid	NOT NULL	Primary key
`team_id`	integer	NOT NULL	Team this export belongs to
`name`	text	NOT NULL	Human-readable name
`model`	varchar(64)	NULL	Data model: `events`, `persons`, or `sessions`
`interval`	varchar(64)	NOT NULL	Schedule frequency: `hour`, `day`, `week`, `every 5 minutes`, `every 15 minutes`
`paused`	integer	NOT NULL	Whether the export is paused (1 = paused, 0 = active)
`deleted`	integer	NOT NULL	Soft-delete flag (1 = deleted, 0 = active)
`destination_id`	uuid	NOT NULL	FK to the destination configuration (not queryable as a system table)
`timezone`	varchar(240)	NOT NULL	IANA timezone for scheduling (e.g. `UTC`, `America/New_York`)
`interval_offset`	integer	NULL	Offset in seconds from the default interval start time
`created_at`	timestamp with tz	NOT NULL	Creation timestamp
`last_updated_at`	timestamp with tz	NOT NULL	Last modification timestamp
`last_paused_at`	timestamp with tz	NULL	When the export was last paused
`start_at`	timestamp with tz	NULL	Earliest time for scheduled runs
`end_at`	timestamp with tz	NULL	Latest time for scheduled runs

Column	Type	Nullable	Description
`id`	uuid	NOT NULL	Primary key
`team_id`	integer	NOT NULL	Team this backfill belongs to
`batch_export_id`	uuid	NOT NULL	FK to the parent batch export
`start_at`	timestamp with tz	NULL	Start of the backfill time range
`end_at`	timestamp with tz	NULL	End of the backfill time range
`status`	varchar(64)	NOT NULL	Current status (see values below)
`created_at`	timestamp with tz	NOT NULL	Creation timestamp
`finished_at`	timestamp with tz	NULL	Completion timestamp
`last_updated_at`	timestamp with tz	NOT NULL	Last modification timestamp
`total_records_count`	bigint	NULL	Total records exported (populated after completion)