Open-Meteo
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 Open-Meteo to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Pull weather and air quality data from Open-Meteo into the PostHog Data warehouse, so you can join it against your own events.
Open-Meteo is free for non-commercial use and needs no API key. Commercial plans issue a key that also routes requests to Open-Meteo's reserved-capacity hosts, so add one below if you have it.
Open-Meteo has no endpoint that lists locations, so enter one location per line as latitude,longitude. An optional label is allowed: latitude,longitude,label. For example:
51.5074,-0.1278,London
40.7128,-74.0060,New York
The archive tables backfill hourly and daily history from the start date you set, then sync incrementally. The forecast and air quality tables always hold the current rolling window, because their values are revised on every model run.
Free use is licensed CC BY 4.0 and requires attribution to Open-Meteo.
Configuration
| Option | Type | Required |
|---|---|---|
Locations | textarea | Yes |
Historical start date | text | No |
API key (commercial plans only) | password | No |
Linking Open-Meteo to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Open-Meteo
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import