Connector

Email Open Holidays reports to your team on a schedule

Load Open Holidays into your data warehouse first, link it to the rest of your data with SQL keys, then send the next public holidays, in the inbox of the people who plan campaigns and staffing. The email comes from your source of truth, not from a hand-built export.

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

Get started free

Hand this to your AI

Campaign and staffing plans miss a public holiday because nobody reminded the planners before it arrived.

Paste this into your AI assistant. It loads Open Holidays into a Data Mart in your data warehouse and emails the next public holidays for your countries to the planners on a schedule.

The prompt

email the public holidays from Open Holidays for our countries in the next 30 days to the campaign and staffing planners every Monday

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 Open Holidays does not go straight to email

Open Holidays lists public holidays by date, not how a holiday moved your sales. An email built straight from the source sends the source's own numbers to an inbox with nothing to check them against; a scheduled export is no better, because it does not tie them to the rest of the business reliably, at scale or business-ready, so the join happens in a data warehouse first.

  • A holiday has a date, a name and a type, with no orders or visits to read it against
  • The data analyst links the tables by SQL keys and controls what an email may say
  • Recipients get one readable message instead of a CSV to open
Open HolidaysHoliday calendar
Email
No link to sales
Data warehouseJoined by id
OrdersOrders by day
Web analyticsTraffic by day

S01 · Step 1

Step 1: Load Open Holidays into your data warehouse first

Create a Data Mart with Open Holidays as the data source and choose where the data lands. It works with any popular data warehouse.

  • One endpoint, Public Holidays, with seven fields, in one table
  • Pick a country ISO code and a language for holiday names
  • Open the Open Holidays connector for your data warehouse below
Open Holida…Data Mart
Your data warehouseGoogle BigQueryAWS AthenaSnowflakeAWS RedshiftDatabricks
open_holidays.public_holidays

S03 · Step 3

Step 3: Email Open Holidays reports to your recipients

Add an email destination with the recipients' addresses, separated by commas, semicolons or new lines, and attach a report of the Open Holidays Data Mart. The subject and the body are Markdown, and a table placeholder drops the rows into the body.

  • The table carries date, name, nationwide and type
  • Allow-list the sending address insights@e.owox.com so the message reaches inboxes
  • Run it once with Create & Run report to see the email before the schedule starts
EmailWeeklyHoliday calendar, week in reviewdatenamenationwidetype

S04 · Step 4

Step 4: Schedule the Open Holidays email and add a short analysis

Add a trigger in the report's Automate Report Runs section or on the Data Mart's Triggers tab, for example every weekday morning or Monday and Wednesday at a set hour in your time zone. Write the reading under the table.

  • Send always, only when the result is not empty, or only when it is empty
  • The reading is drawn from the report's fields and says only what the data shows
  • Attach a pre-built Insight instead of plain text when you want it written for you
EmailHoliday calendar, week in reviewdatenamenationwidetypeAnalysisThe coming public holidays, with date, name and type.The nationwide flag separates country-wide days from local ones.Check these dates before you set the next send or the next rota.

S05 · Step 5

Step 5: Reuse Open Holidays inside OWOX MCP

The Data Mart behind your email report also works in OWOX MCP, your AI assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.

  • Ask in plain words; the answer comes from your data warehouse
  • An Open Holidays question worth repeating becomes the next scheduled email
OWOX MCPShow orders_count on holidays and other daysorders_count
Google SheetsOpen
ExcelOpen

Recent updates

Why OWOX

Why OWOX for Open Holidays by email

Scheduled exports and hand-mailed screenshots put numbers in an inbox. OWOX also keeps the data yours, linked and ready to model.

  • You own the data. Open Holidays lands in your own data warehouse, in tables you control.
  • Dates before the plan. Planners get the coming holidays by email ahead of the week, with the flag that says who they affect.
  • Nothing to open. Recipients read the table and the analysis in the message, with no login to a dashboard or to OWOX.
  • Same numbers everywhere. The Open Holidays Data Mart behind the email also feeds your reports and your AI assistant.
  • You set the rule. A report sends always, only when it has rows, or only when it is empty, so a quiet week does not fill inboxes.

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