PostHog

Connect your PostHog analytics to your data warehouse. Sync events, persons, feature flags, and experiments to BigQuery, Redshift, Postgres, Databricks, and more.

Using the Erathos platform

When selecting PostHog as a new connector on the Erathos platform, you will need to name your connection and fill in the following form:

• Token — Your PostHog personal API key used for authentication

With this connection created you can seamlessly move your PostHog data to your BigQuery, Redshift or Postgres data warehouse.

How to find my token?

To authenticate with PostHog, you need a personal API key. Log in to your PostHog instance, click on your profile in the top-right corner, and navigate to Settings → Personal API keys. Click + Create personal API key, give it a name (e.g. "Erathos"), and copy the generated key.

Paste the personal API key into the Token field on the Erathos platform connection form. Click Save and close to complete setup.

Endpoints and fields

actions

Sync type availability: Full-refresh

Field	Type
id	integer
name	text
description	text
created_at	timestamp
updated_at	timestamp
created_by_id	integer
deleted	boolean

annotations

Sync type availability: Full-refresh

Field	Type
id	integer
content	text
created_at	timestamp
date_marker	timestamp
created_by_id	integer

cohorts

Sync type availability: Full-refresh

Field	Type
id	integer
name	text
description	text
created_at	timestamp
updated_at	timestamp
is_static	boolean
created_by_id	integer

dashboards

Sync type availability: Full-refresh

Field	Type
id	integer
name	text
description	text
created_at	timestamp
updated_at	timestamp
created_by_id	integer
deleted	boolean

events

Sync type availability: Full and incremental refresh

Cursor: created_at

Field	Type	Cursor
id	text
event	text
distinct_id	text
timestamp	timestamp
properties	text
elements	text
created_at	timestamp	✓

experiments

Sync type availability: Full-refresh

Field	Type
id	integer
name	text
description	text
created_at	timestamp
updated_at	timestamp
created_by_id	integer

feature_flags

Sync type availability: Full-refresh

Field	Type
id	integer
key	text
name	text
active	boolean
created_at	timestamp
created_by_id	integer
deleted	boolean

persons

Sync type availability: Full-refresh

Field	Type
id	text
distinct_id	text
properties	text
created_at	timestamp
is_identified	boolean
name	text
email	text

session_recordings

Sync type availability: Full-refresh

Field	Type
id	text
session_id	text
distinct_id	text
viewed	boolean
start_time	timestamp
end_time	timestamp
duration	float
created_at	timestamp

surveys

Sync type availability: Full-refresh

Field	Type
id	integer
name	text
description	text
created_at	timestamp
updated_at	timestamp
created_by_id	integer

Entity Relationships