Open Holidays Connector to AWS Athena
Own your Open Holidays data in AWS Athena with OWOX Data Marts. Collect granular, analytics-ready Open Holidays data into AWS Athena, control schema and refresh logic, and reuse the data across BI tools and AI Insights.
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 seriesopen_holidays_public_holidays
Open Holidays data schema
Public Holidays 7 fields · open_holidays_public_holidays
| 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 |
Data Partner You Can Trust
users
175K
Executives and data analysts across 20+ industries
G2 rating
4.9★
“A trusted data analytics partner” — verified review
Customers
ArtPix 3D — transparent KPI calculationsasset pending
Avrora — a partner we could trustasset pending
Avrora — clarity and confidence to decide fastasset pending
Avrora — reliable analytics systemasset pending
Avrora — transformed approach to BIasset pending
Better&Stronger — always there to helpasset pending
Better&Stronger — rich educational resourcesasset pending
Domas R. (G2) — data we can actually trustasset pending
Domas R. (G2) — solution to most data challengesasset pending
Hiveon — key metrics built our wayasset pending
Khrystyna G. (G2) — simple tool, amazing supportasset pending
MatahariMall — less time on reportingasset pending
MotionVFX — data quality to predict budgetasset pending
MotionVFX — exceeded our expectationsasset pending
MotionVFX — no decisions without analysisasset pending
MotionVFX — transparency behind every KPIasset pending
ON Clinic — cost per acquisition by serviceasset pending
ON Clinic — data for regional KPIsasset pending
ON Clinic — know AOV by segmentasset pending
IT
QVC — reports in line with business needsasset pending
QVC — totally satisfied with resultasset pending
Retail
IT
Wojciech W. (G2) — accurate data, more revenueasset pending
Wojciech W. (G2) — reliable business partnerasset pending
Wojciech W. (G2) — transparent, honest cooperation termsasset pending
Business & Consumer Services
ZOOD — foundation for years to comeasset pending
Every claim has a receipt.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
“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.”
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
“We regained time. And time is the one resource that never comes back.”


