Fivetran documentation

Search the docs

/

PostHog

Explore the interactive ERD

Table & Field Reference

annotation

Column	Type	Keys
`id`	Unknown	PK
`created_by_uuid`	Unknown	FK
`project_id`	Unknown	FK
`content`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`creation_type`	Unknown
`dashboard_item`	Unknown
`date_marker`	Unknown
`deleted`	Unknown
`scope`	Unknown
`updated_at`	Unknown

session

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`is_numerical`	Unknown
`is_seen_on_filtered_events`	Unknown
`name`	Unknown
`property_type`	Unknown
`tags`	Json

cohort

Column	Type	Keys
`id`	Unknown	PK
`created_by_uuid`	Unknown	FK
`count`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`deleted`	Unknown
`description`	Unknown
`error_calculating`	Unknown
`filters_properties_type`	Unknown
`filters_properties_value`	Json
`groups`	Json
`is_calculating`	Unknown
`is_static`	Unknown
`last_calculation`	Unknown
`name`	Unknown
`project_id`	Unknown

app_url

Column	Type	Keys
`app_url`	Unknown	PK
`project_id`	Unknown	PKFK

test_account_filter

Column	Type	Keys
`_fivetran_id`	String	PK
`project_id`	Unknown	FK
`key`	Unknown
`operator`	Unknown
`type`	Unknown
`value`	Json

path_cleaning_filter

Column	Type	Keys
`_fivetran_id`	String	PK
`project_id`	Unknown	FK
`key`	Unknown
`operator`	Unknown
`type`	Unknown
`value`	Json

persons_display_name_property

Column	Type	Keys
`person_display_name_property`	Unknown	PK
`project_id`	Unknown	PKFK

live_events_column

Column	Type	Keys
`live_events_column`	Unknown	PK
`project_id`	Unknown	PKFK

project

Column	Type	Keys
`id`	Unknown	PK
`access_control`	Unknown
`anonymize_ips`	Unknown
`completed_snippet_onboarding`	Unknown
`created_at`	Unknown
`data_attribute`	Json
`effective_membership_level`	Unknown
`excluded_event_name`	Json
`excluded_event_property_name`	Json
`excluded_person_property_name`	Json
`has_group_types`	Unknown
`ingested_event`	Unknown
`is_demo`	Unknown
`name`	Unknown
`organization`	Unknown
`primary_dashboard`	Unknown
`session_recording_opt_in`	Unknown
`slack_incoming_webhook`	Unknown
`timezone`	Unknown
`updated_at`	Unknown
`uuid`	Unknown

users

Column	Type	Keys
`uuid`	Unknown	PK
`anonymize_data`	Unknown
`date_joined`	Unknown
`distinct_id`	Unknown
`email`	Unknown
`email_opt_in`	Unknown
`first_name`	Unknown
`has_password`	Unknown
`is_impersonated`	Unknown
`is_staff`	Unknown
`toolbar_mode`	Unknown

insight_tag

Column	Type	Keys
`tags`	Unknown	PK
`insight_id`	Unknown	PKFK

insight

Column	Type	Keys
`id`	Unknown	PK
`created_by_uuid`	Unknown	FK
`last_modified_by_uuid`	Unknown	FK
`project_id`	Unknown	FK
`created_at`	Unknown
`created_by_id`	Unknown
`dashboards`	Json
`deleted`	Unknown
`derived_name`	Unknown
`description`	Unknown
`effective_privilege_level`	Unknown
`effective_restriction_level`	Unknown
`favorited`	Unknown
`filters_hash`	Unknown
`is_sample`	Unknown
`last_modified_at`	Unknown
`last_modified_by_id`	Unknown
`last_refresh`	Unknown
`name`	Unknown
`orders`	Unknown
`refreshing`	Unknown
`result`	Json
`saved`	Unknown
`short_id`	Unknown
`timezone`	Json
`updated_at`	Unknown
`filter_`

person_name

Column	Type	Keys
`person_name`	Unknown	PK
`person_id`	Unknown	PKFK

person

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`is_identified`	Unknown
`name`	Unknown
`project_listing_person_id`	Unknown
`type`	Unknown
`uuid`	Unknown
`property_`

cohort_person

Column	Type	Keys
`cohort_id`	Unknown	PKFK
`person_uuid`	Unknown	PKFK
`project_id`	Unknown	FK
`created_at`	Unknown
`is_identified`	Unknown
`matched_recordings`	Json
`name`	Unknown
`type`	Unknown
`value_at_data_point`	Unknown

session_recording

Column	Type	Keys
`id`	Unknown	PK
`person_uuid`	Unknown	FK
`project_id`	Unknown	FK
`active_seconds`	Unknown
`activity_score`	Unknown
`click_count`	Unknown
`console_error_count`	Unknown
`console_log_count`	Unknown
`console_warn_count`	Unknown
`distinct_id`	Unknown
`end_time`	Unknown
`inactive_seconds`	Unknown
`keypress_count`	Unknown
`mouse_activity_count`	Unknown
`ongoing`	Unknown
`person_id`	Unknown
`recording_duration`	Unknown
`snapshot_source`	Unknown
`start_time`	Unknown
`start_url`	Unknown
`storage`	Unknown
`viewed`	Unknown

filter_group_property

Column	Type	Keys
`_fivetran_id`	String	PK
`feature_flag_filter_group_index`	Unknown	FK
`feature_flag_id`	Unknown	FK
`key`	Unknown
`operator`	Unknown
`type`	Unknown
`value`	Json

feature_flag_filter_group

Column	Type	Keys
`index`	Unknown	PK
`feature_flag_id`	Unknown	PKFK
`rollout_percentage`	Unknown

feature_flag

Column	Type	Keys
`id`	Unknown	PK
`created_by_uuid`	Unknown	FK
`project_id`	Unknown	FK
`active`	Unknown
`created_at`	Unknown
`created_by_id`	Unknown
`deleted`	Unknown
`ensure_experience_continuity`	Unknown
`filters_multivariate`	Json
`is_simple_flag`	Unknown
`key`	Unknown
`name`	Unknown
`rollout_percentage`	Unknown

batch_export_event

Column	Type	Keys
`id`	Unknown	PK
`distinct_id`	Unknown	FK
`created_at`	Instant
`elements_chain`	Unknown
`event`	Unknown
`inserted_at`	Instant
`person_id`	Unknown
`project_id`	Unknown
`time_stamp`	Instant
`person_properties_`
`properties_`