Connector

Query Open Holidays calendars in AWS Athena

Load public holiday calendars by country from Open Holidays into your own AWS account with OWOX Data Marts, then join the dates to your orders and ad spend to tell a real drop in demand from a calendar effect. Read it from an Athena query.

Open HolidaysConnectedPublic Holidays
Data MartPublishedone definition
AWS AthenaDateIdNameDaily 09:00
Refreshed on a schedule. No exports, no copy-paste.

Get started free

Hand this to your AI

A sales dip in a holiday week looks like lost demand in AWS Athena until someone checks the calendar by hand.

Paste this into your AI assistant. It loads Open Holidays calendars by country into AWS Athena as a Data Mart and joins the dates to your orders and ad spend.

The prompt

load the Open Holidays public holiday calendar for our countries into AWS Athena and flag every order day and ad day that fell on a national or regional holiday

Open in ClaudeOpen in ChatGPT

Endpoints

Open Holidays Endpoints

Documentation

1 Open Holidays endpoints you can import. Each lands in its own table in your data warehouse.

S00 · Why

Why keep a holiday calendar next to your sales and ad spend

A dip in the week of a public holiday looks like lost demand until someone checks the calendar. With the dates in your data warehouse, the check is a join, not a guess. The calendar sits in your own AWS account, beside your own tables.

  • Flag every order and ad day that fell on a holiday
  • Separate a national holiday from a regional one with one field
  • Compare a dip with the calendar before anyone calls it a trend
Open HolidaysHoliday dates
Shop ordersSales by day
Ad platformsSpend by day
Your data warehouseAWS AthenaDateHolidaySalesJoined by idSales dip on a weekdayExplained by a holidayOne join on date shows whether a dip fell on a holiday.

S01 · Step 1

Step 1: Connect Open Holidays and pick the fields

Create a Data Mart on your Athena data storage and choose Open Holidays as the data source. The source needs no credentials, so there is no token or service account to set up. Then tick the fields.

  • One endpoint, Public Holidays, with 7 fields to choose from
  • A time series: every holiday row carries its date, ready to filter in an Athena query
New Data MartChoose a sourceShopifyOpen HolidaysGoogle AdsAuthorizeConnectedEndpointPublic Holidays
Public Holidays7 fieldsiddatenametyperegionalScopenationwide

S02 · Step 2

Step 2: Load Open Holidays calendars into an Athena database and table

Choose the Athena database and table, or keep the pre-filled ones. Run it and the first load lands in your own AWS account.

  • Each row is one holiday with its date, name, type and scope
DestinationAWS AthenaDatabaseopen_holidaysTablepublic_holidaysRun
Run HistoryPendingRunningSuccessIncremental load
Tableopen_holidays.public_holidays

S03 · Step 3

Step 3: Read the output schema in plain words

After the first run you get the output schema: every field with a plain description. Your data quality checks can read it too.

  • name is the holiday's name in the language you requested
  • nationwide is true or false, so a regional holiday cannot pass for a national one
open_holidays.public_holidaysOutput schemaFieldDescriptionidUnique identifier for the holidaydateDate of the holidaynameName of the holiday in the…typeType of holiday (public…regionalScopeRegional scope of the holidaynationwideWhether the holiday is nationwide

S05 · Step 5

Step 5: Schedule the refresh and backfill history

Set it once. A scheduled refresh keeps your Athena table current, and a manual backfill loads any past period.

  • Backfill a custom start and end date to cover the periods you want to explain
  • Run History shows every load into your Athena database
ScheduleRun on a scheduleDaily 09:00
BackfillRun backfill
Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Reuse the same calendar everywhere

One Athena table feeds your data model, spreadsheets, dashboards, AI assistants like Claude and ChatGPT, and scheduled AI insights in Slack or email.

  • Every report flags holidays the same way, so the totals agree
  • Ask an AI assistant whether last week's dip fell on a holiday and get an answer from the table
Open Holida…Data MartPublished
Holiday flags
Google Sheets
Data Studio dashboards
Claude, ChatGPT
Slack, email

Recent updates

Why OWOX

Why OWOX for Open Holidays in AWS Athena

Someone checking each dip against a holiday list by hand gets an answer once. OWOX keeps the calendar in the table where your orders and ad spend already are, so every report can check it.

  • In your AWS account. The table sits in your own AWS account, queried through Athena like your other tables.
  • Your query, your account. Analysts reach the table with an Athena query, and the join lives in the Data Mart.
  • Calendar by country. The holidays come from Open Holidays by country, with their regional and temporal scope.
  • History you can use. Backfill past years, so last year's dip can be explained too.
  • Ready for a data model. The date is what the join runs on, so linking holidays to orders and ad spend is one line in your model.

Book a callGet started free

Trust

The Data Partner You Can Trust

users

175K Source: Internal OWOX data as of 2026-11-11

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers