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
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
weather_archive_hourly | Hourly historical weather (ERA5 reanalysis, 1940 onwards) for each configured location. https://open-meteo.com/en/docs/historical-weather-api | Incremental, Full refresh | time_utc | location_id, time_utc |
weather_archive_daily | Daily aggregated historical weather (ERA5 reanalysis, 1940 onwards) for each configured location. https://open-meteo.com/en/docs/historical-weather-api | Incremental, Full refresh | time_utc | location_id, time_utc |
weather_forecast_hourly | Hourly weather forecast for each configured location, covering the past 7 days and the next 16 days. Full refresh only, because forecast values for a given hour are revised on every model run. https://open-meteo.com/en/docs | Full refresh | — | location_id, time_utc |
weather_forecast_daily | Daily weather forecast for each configured location, covering the past 7 days and the next 16 days. Full refresh only, because forecast values for a given day are revised on every model run. https://open-meteo.com/en/docs | Full refresh | — | location_id, time_utc |
weather_current | Current weather conditions for each configured location. One row per location per sync; use the append sync method to accumulate a time series. https://open-meteo.com/en/docs | Append only, Full refresh | time_utc | location_id, time_utc |
air_quality_hourly | Hourly air quality (particulates, gases and AQI) for each configured location, covering the past 7 days and the next 5 days. Full refresh only, because the CAMS values are revised on every model run. https://open-meteo.com/en/docs/air-quality-api | Full refresh | — | location_id, time_utc |