Meteostat

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.

Learn more

Connect Meteostat to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Sync historical weather and climate data for weather stations from the Meteostat JSON API (hosted on RapidAPI). Get a free API key by subscribing to the Meteostat API listing on RapidAPI — the free plan includes 500 requests per month.

Meteostat has no account-scoped list of stations, so list the weather station IDs you want to sync.

Configuration

Option	Description
`RapidAPI key` Type: password Required: True
`Weather station IDs` Type: text Required: True	Comma-separated list of Meteostat station IDs. Up to 25 stations.
`Unit system` Type: select Required: True
`Start date` Type: text Required: False	Earliest day to sync (YYYY-MM-DD). Defaults to 2015-01-01 to keep the initial sync within a typical RapidAPI free-tier quota.

Linking Meteostat to PostHog

Go to the Data pipeline page in PostHog
Click New source and select Meteostat
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
`Hourly`	Historical hourly weather observations for a station, with gaps optionally filled by statistically optimized model data.	Incremental, Full refresh	time	—
`Daily`	Historical daily weather statistics for a station, aggregated from observations and model data.	Incremental, Full refresh	date	—
`Monthly`	Historical monthly weather statistics for a station, aggregated from hourly observations, daily records, and model data.	Incremental, Full refresh	date	—