Connector

Load Open Holidays calendars into Snowflake

Load public holiday calendars by country from Open Holidays into your own Snowflake 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 Snowflake.

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

Get started free

Hand this to your AI

A regional holiday empties one region's sales, and the Snowflake report shows it as a company-wide dip.

Paste this into your AI assistant. It loads Open Holidays calendars into Snowflake as a Data Mart with the nationwide and regional scope fields, ready to join to sales by date and region.

The prompt

load Open Holidays national and regional holidays for our countries into Snowflake and split last month's sales by holiday type, nationwide versus regional

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 Snowflake 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 warehouseSnowflakeDateHolidaySalesJoined 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 Snowflake and pick 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 Snowflake
New Data MartChoose a sourceShopifyOpen HolidaysGoogle AdsAuthorizeConnectedEndpointPublic Holidays
Public Holidays7 fieldsiddatenametyperegionalScopenationwide

S02 · Step 2

Step 2: Load Open Holidays calendars into a Snowflake table

Choose your Snowflake database; the schema and table are pre-filled and editable. Run it and the first load lands in your own Snowflake account.

  • Each row is one holiday with its date, name, type and scope
DestinationSnowflakeDatabaseSchemaopen_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 Snowflake 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 Snowflake 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 Snowflake 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 Snowflake

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.

  • Inside your account. The table lives in your Snowflake account, next to the tables you already query and under your own roles.
  • Your SQL, your account. Analysts reach the table with Snowflake SQL they already write, 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