Collect Open Holidays calendars into your warehouse
The Open Holidays connector loads public holiday data by country into your own warehouse, so you can tell a real drop in demand from a calendar effect.
Available connectors from Open Holidays
Available connectors from Open Holidays
- Open Holidays Connector to ChatGPT1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to Claude1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to AWS Athena1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to AWS Redshift1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to Databricks1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to Google BigQuery1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to Snowflake1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to API1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to Data Studio1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to Google Sheets1 endpoint7 fieldsPublic Holidays
- Open Holidays Connector to Microsoft Excel1 endpoint7 fieldsPublic Holidays
- Open Holidays Insights to Email1 endpoint7 fieldsPublic Holidays
- Open Holidays Insights to Google Chat1 endpoint7 fieldsPublic Holidays
- Open Holidays Insights to Microsoft Teams1 endpoint7 fieldsPublic Holidays
- Open Holidays Insights to Slack1 endpoint7 fieldsPublic Holidays
Open Holidays Endpoints
1 Open Holidays endpoints you can import. Each lands in its own table in your warehouse.
Public Holidays
Contains public holidays data for different countries and languages
7 fieldsTime series
Open Holidays Public Holidays schema
7 fieldsTime seriesSchema on GitHubopen_holidays_public_holidays
Contains public holidays data for different countries and languages
| Field | Type | Description |
|---|---|---|
id | STRING | Unique identifier for the holiday |
date | DATE | Date of the holiday |
name | STRING | Name of the holiday in the specified language |
type | STRING | Type of holiday (public, school, etc.) |
regionalScope | STRING | Regional scope of the holiday |
temporalScope | STRING | Temporal scope of the holiday |
nationwide | BOOLEAN | Whether the holiday is nationwide |
Why Collect Open Holidays Data Into Your Warehouse With OWOX?
Sales dip in the week of a public holiday, and the dashboard shows a drop. Without the calendar next to the numbers, someone has to guess whether demand fell or the shops were closed. The Open Holidays connector puts the calendar in your warehouse so you can join it to your data and check.
Collect to your warehouse
The data lands in your warehouse, not in OWOX, so you own it. Every connector is included in every OWOX Cloud plan, with no per-connector bill.
Zero-maintenance syncs
The connector is open source under the MIT license, so you can read the code. A Connector Trigger runs it on the schedule you set.
Full-funnel joins
Join the calendar to orders, traffic or ad spend in a Data Mart. The SQL behind every join stays visible.
R01 · Collect
Collect All Your Open Holidays Data With Zero Engineering
The connector has one endpoint in the OWOX catalog, Public Holidays. It covers public holidays for different countries and languages, is a time series and lands in a table named open_holidays_public_holidays. The table has seven fields.
| Field | Type | What it holds |
|---|---|---|
| id | STRING | A unique identifier for the holiday |
| date | DATE | The date of the holiday |
| name | STRING | The holiday’s name in the requested language |
| type | STRING | The type of holiday, such as public or school |
| regionalScope | STRING | The regional scope of the holiday |
| temporalScope | STRING | The temporal scope of the holiday |
| nationwide | BOOLEAN | Whether the holiday applies nationwide |
The connector documentation says the source also covers school holidays and holiday transfer data. The source needs no credentials. To start:
- Add a storage to receive the data: Google BigQuery, Snowflake, AWS Redshift, AWS Athena or Databricks.
- Create a Connector Data Mart and choose Open Holidays as the platform.
- Publish the Data Mart and run it for the first import.
- Add a Connector Trigger to schedule recurring imports.
The connector documentation has the full setup guide.
R02 · Report
Build Reports With Open Holidays Data That Everyone Trusts
Once the calendar is in your warehouse, it behaves like any other table you own.
- Join
dateand country to your orders and flag the days that were holidays. - Use
nationwideto separate a national holiday from a regional one. - Compare a dip in demand with the calendar before anyone calls it a trend.
- Define the join once in a Data Mart, so every report uses the same calendar.
R03 · Why OWOX
Deliver Open Holidays Data to the Tools Your Team Uses
A Report delivers one Data Mart to one destination, and each Data Mart can feed many destinations.
- Push mode: OWOX writes the data on a manual or scheduled run. Google Sheets, email, Slack, Microsoft Teams and Google Chat work this way.
- Pull mode: the tool asks OWOX for the data when a user refreshes it. Data Studio and Microsoft Excel work this way.
- AI assistants such as Claude and ChatGPT read the Data Mart, not the raw tables, so answers use your definitions.
Why Use OWOX Connectors to Collect Your Open Holidays Data?
Real drop or calendar effect
Reference data tells a real drop in demand apart from a calendar effect.
Your data stays yours
The calendar sits in a warehouse you own. OWOX does not keep a copy.
No credentials to manage
The source is public reference data, so nothing secret sits in the connector.
Scheduled, not manual
A Connector Trigger refreshes the table on your schedule, so nobody retypes holiday lists.
Readable by anyone
The connector code is open source, so you can see exactly what it fetches.
Define once, reuse everywhere
One Data Mart with the calendar feeds Sheets, Excel, Data Studio and AI assistants.
Fewer unexplained variances
A shared calendar gives every report the same answer to why a day looked different.
Free of per-connector cost
All connectors are included in every OWOX Cloud plan.
Not testimonials. Comment threads.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
Nodari RizunFounder & CEO, Pürblack®“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
Mark SimmonsCMO, Pürblack®“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
Nodari RizunFounder & CEO, Pürblack®“We regained time. And time is the one resource that never comes back.”
Start collecting Open Holidays data
Add the connector, pick the fields, set a schedule. The source needs no credentials.
- Internal OWOX data as of 2026-10-02
- G2 reviews of OWOX
- npm installs stat