Connector

Send Open Holidays calendars to Databricks

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

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

Get started free

Hand this to your AI

Demand models in Databricks miss public holidays because the calendar sits in a file someone updates once a year.

Paste this into your AI assistant. It loads Open Holidays calendars by country into Databricks as a Data Mart on a schedule, ready to join to orders and ad spend by date.

The prompt

load Open Holidays public and regional holidays for our countries into Databricks on a schedule, so my demand model can use a holiday flag by date and country

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 Databricks workspace, 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 warehouseDatabricksDateHolidaySalesJoined 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, choose Open Holidays as the data source and tick only the fields you need. 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 Databricks SQL
New Data MartChoose a sourceShopifyOpen HolidaysGoogle AdsAuthorizeConnectedEndpointPublic Holidays
Public Holidays7 fieldsiddatenametyperegionalScopenationwide

S02 · Step 2

Step 2: Load Open Holidays calendars into a Databricks table

The catalog is main, and the schema and table are pre-filled; change those two if you like. Run it and the first load lands in your own Databricks workspace.

  • Each row is one holiday with its date, name, type and scope
DestinationDatabricksCatalogmainSchemaopen_holidaysTablepublic_holidaysRun
Run HistoryPendingRunningSuccessIncremental load
Tablemain.open_holidays.public_hol…

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
main.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 Databricks 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 Databricks 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 Databricks 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 Databricks

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 workspace. The table lands in your own Databricks workspace, in the main catalog, so the rest of your lakehouse can use it.
  • Your SQL, your workspace. Analysts reach the table from Databricks SQL, and the join lives in the Data Mart instead of a notebook.
  • 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