Snowplow Analytics
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect Snowplow Analytics to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Enter your Snowplow BDP Console API credentials to pull your pipeline health and data modeling job data into the PostHog Data warehouse.
Find your Organization ID on the Console's Manage organization page, then create an API key (a key ID + key secret pair) under Console settings → API keys. Note that all Snowplow Console API keys carry admin privileges, so store them carefully.
This connector talks to the standard BDP Console host (console.snowplowanalytics.com); privately-hosted Console deployments are not supported yet.
Configuration
| Option | Type | Required |
|---|---|---|
Organization ID | text | Yes |
API key ID | text | Yes |
API key | password | Yes |
Linking Snowplow Analytics to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Snowplow Analytics
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
pipelines | The Snowplow pipelines in your organization. | Full refresh | — | — |
users | Users of your Snowplow BDP Console organization. | Full refresh | — | — |
data_models | Data models (dbt or SQL Runner) configured to run against your warehouse. | Full refresh | — | — |
data_structures | Data structures (event and entity schemas) registered in your organization, with the most recent deployment per environment. | Full refresh | — | — |
job_runs | Snowplow only retains job run history for about the preceding week, so historical backfill beyond that is not possible | Incremental, Full refresh | startTime | — |
job_run_steps | Snowplow only retains job run history for about the preceding week, so historical backfill beyond that is not possible | Incremental, Full refresh | runStartTime | — |
failed_event_metrics | Failed-event counts per pipeline, error, and time bucket. Snowplow keeps about a week of these aggregates | Incremental, Full refresh | window | — |