NOAA Climate Data Online (NCEI)
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 NOAA Climate Data Online (NCEI) to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Request a free API token from NOAA. Select one dataset and one station for observations. Reference tables can cover the whole dataset. Observations use metric units. Incremental sync reads the previous seven days again. Use a full refresh to collect older corrections. NOAA limits each token to five requests per second and 10,000 requests per day.
Configuration
| Option | Type | Required |
|---|---|---|
API token | password | Yes |
Dataset ID | text | Yes |
Station ID | text | Yes |
Start date | text | Yes |
Linking NOAA Climate Data Online (NCEI) to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select NOAA Climate Data Online (NCEI)
- 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 |
|---|---|---|---|---|
data | Weather observations for the selected dataset and station, converted to metric units. | Incremental, Full refresh | date | — |
datasets | NOAA datasets with observations from the selected station. | Full refresh | — | — |
stations | Weather observing stations that support the selected dataset. | Full refresh | — | — |
datatypes | Measurement types available for the selected dataset and station. | Full refresh | — | — |
datacategories | Groups of measurement types available for the selected dataset and station. | Full refresh | — | — |
locations | Geographical locations with observations in the selected dataset. | Full refresh | — | — |
locationcategories | Groups of similar locations available for the selected dataset. | Full refresh | — | — |