Nager.Date
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 Nager.Date to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Pull public holiday data from the free Nager.Date API into the PostHog Data warehouse.
The API is open, so no credentials are required. Enter the ISO 3166-1 alpha-2 country codes you want to track, one per line or comma separated. For example:
US
GB
DE
A holidays table like this is commonly joined against event, order, or traffic timestamps by date and country to explain dips and seasonality.
The API only serves a rolling window of years around today, and it has no "changed since" filter, so every table syncs as a full refresh on each run. This also picks up holiday corrections the source publishes after the fact.
Configuration
| Option | Type | Required |
|---|---|---|
Country codes | textarea | Yes |
Linking Nager.Date to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select Nager.Date
- 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 |
|---|---|---|---|---|
Countries | Countries the Nager.Date API publishes public holiday data for. | Full refresh | — | — |
CountryInfo | Country names and region for each configured country, with bordering countries. | Full refresh | — | — |
PublicHolidays | Public holidays for each configured country, for the years the API currently supports. | Full refresh | — | — |
NextPublicHolidays | The next public holidays occurring within 365 days for each configured country. | Full refresh | — | — |