FRED
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 FRED to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Pull US and international economic time series from FRED, the Federal Reserve Bank of St. Louis database, into the PostHog Data warehouse.
Request a free API key at fred.stlouisfed.org/docs/api/api_key.html. FRED has around 800,000 series, so pick the ones you want: a series ID is the code at the end of its FRED page URL, such as UNRATE for the unemployment rate or CPIAUCSL for CPI.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Series IDs | textarea | Yes |
Linking FRED to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select FRED
- 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 |
|---|---|---|---|---|
series | Metadata for each economic data series listed in the source's series IDs, including its title, frequency, units and when it was last updated. | Full refresh | — | — |
observations | Observation values over time for each series in the source's series IDs. One row per series and observation date. | Full refresh | — | — |
series_categories | Categories each series in the source's series IDs belongs to, in FRED's category tree. | Full refresh | — | — |
series_tags | Tags attached to each series in the source's series IDs, covering frequency, geography, source and seasonal adjustment. | Full refresh | — | — |
series_releases | The release each series in the source's series IDs is published in. | Full refresh | — | — |
releases | Every release of economic data published on FRED, such as the Employment Situation or the Consumer Price Index. | Full refresh | — | — |
release_dates | The publication calendar for FRED releases, including scheduled future dates. | Full refresh | — | — |
sources | Organizations that publish the data behind FRED releases, such as the Bureau of Labor Statistics. | Full refresh | — | — |
tags | Every tag FRED assigns to series, used to filter and group them by frequency, geography, publisher and seasonal adjustment. | Full refresh | — | — |