Connector

Bring Open Holidays calendars into AWS Redshift

Load public holiday calendars by country from Open Holidays into your Redshift cluster or workgroup 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 a Redshift query.

Open HolidaysConnectedPublic Holidays

Data MartPublishedone definition

AWS RedshiftDateIdNameDaily 09:00

Refreshed on a schedule. No exports, no copy-paste.

Get started free

Hand this to your AI

Reports in AWS Redshift treat every public holiday as an ordinary weekday, so a quiet day reads as a trend.

Paste this into your AI assistant. It loads Open Holidays calendars by country into AWS Redshift as a Data Mart, so a holiday flag joins to orders and ad spend by date.

The prompt

load Open Holidays public holidays for the countries we sell in into AWS Redshift and add a holiday column to my daily sales and ad spend table

Open in Claude Open in ChatGPT

Endpoints

Open Holidays Endpoints

Documentation

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

Public Holidays
Contains public holidays data for different countries and languages
7 fieldsTime series

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 Redshift cluster or workgroup, 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 RedshiftDateHolidaySalesJoined 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 Redshift data storage, choose Open Holidays as the data source and select the fields. The source needs no credentials, so there is no token or service account to set up.

One endpoint, Public Holidays, with 7 fields to choose from
A time series: every holiday row carries its date, ready to filter in a Redshift query

New Data MartChoose a source

Shopify

Open Holidays

Google AdsAuthorizeConnectedEndpointPublic Holidays

Public Holidays7 fieldsiddatenametyperegionalScopenationwide

S02 · Step 2

Step 2: Load Open Holidays calendars into a Redshift schema and table

The schema and table in your Redshift database are suggested and can be changed. Run it and the first load arrives in your cluster or workgroup.

Each row is one holiday with its date, name, type and scope

DestinationAWS RedshiftSchemaopen_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

S04 · Step 4

Step 4: Link the calendar to your own tables

The calendar does not need other Open Holidays tables. It needs yours: describe each join once in your data model and run it in Redshift.

orders.order_date joins to the holiday date, for the country you loaded, as a plain JOIN in a Redshift query
ad_spend.date joins the same way, so spend is read against the same calendar

Public Holidaysiddatenamenationwide

ordersyour tableorder_daterevenue

ad_spendyour tabledatecost

S05 · Step 5

Step 5: Schedule the refresh and backfill history

Set it once. A scheduled refresh keeps your Redshift 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 Redshift schema

ScheduleRun on a scheduleDaily 09:00

BackfillRun backfill

Run HistoryDaily scheduleManual backfillDaily schedule

S06 · Step 6

Step 6: Reuse the same calendar everywhere

One Redshift 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

Related connectors

Open Holidays to Claude Bank of Canada to AWS Redshift Open Exchange Rates to AWS Redshift Open Holidays to ChatGPT Facebook Ads to AWS Redshift Google Ads to AWS Redshift Microsoft Ads to AWS Redshift TikTok Ads to AWS Redshift Criteo Ads to AWS RedshiftShow 6 moreShow fewer

Recent updates

Why OWOX

Why OWOX for Open Holidays in AWS Redshift

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 cluster. The table belongs to your Redshift cluster or workgroup, so it joins the data your analysts already use there.
Your query, your cluster. Analysts reach the table with a Redshift 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 call Get 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★²

“A trusted data analytics partner” — verified review

npm installs

171K³

In Open Source We Trust

Customers

SaaS

Ecommerce

SaaS