---
title: "Open Holidays to ChatGPT | OWOX MCP"
canonical: "https://www.owox.com/connectors/open-holidays-connector-to-chatgpt"
updated: "2026-09-17"
---

# Open Holidays Connector to ChatGPT

Ask Open Holidays questions in ChatGPT using OWOX Data Marts. Collect Open Holidays data into a governed data mart, then get answers in ChatGPT via OWOX's MCP server — every number traces back to analyst-written SQL.

[Get started free](https://www.owox.com/app-signup)

## Endpoints

## Open Holidays endpoints

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

*   ### Public Holidays

    Contains public holidays data for different countries and languages

    7 fieldsTime series`open_holidays_public_holidays`

## Data schema

## Open Holidays data schema

**Public Holidays** 7 fields · open\_holidays\_public\_holidays

| Field | Type | Description |
| --- | --- | --- |
| `id` | STRING | Unique identifier for the holiday |
| `date` | DATE | Date of the holiday |
| `name` | STRING | Name of the holiday in the specified language |
| `type` | STRING | Type of holiday (public, school, etc.) |
| `regionalScope` | STRING | Regional scope of the holiday |
| `temporalScope` | STRING | Temporal scope of the holiday |
| `nationwide` | BOOLEAN | Whether the holiday is nationwide |

## In ChatGPT

## Ask Open Holidays questions in ChatGPT

You

Did public holidays affect our sales last quarter?

ChatGPT

Public Holidays (open\_holidays\_public\_holidays) lists holidays by date and country. I marked each holiday date in your sales Data Mart for last quarter and compared those days with ordinary days on the same weekday.

This comes from your governed Data Marts through the OWOX MCP server, so it is as fresh as their last scheduled refresh.

You

Which upcoming holidays should we plan campaigns around?

ChatGPT

Filtering the same table to future dates, for the countries you sell in, gives the calendar. I listed them by date so you can set budgets before each one.

## Related connectors

[AWS Athena Connector to ChatGPT](/connectors/aws-athena-connector-to-chatgpt)

[AWS Redshift Connector to ChatGPT](/connectors/aws-redshift-connector-to-chatgpt)

[Bank of Canada Connector to ChatGPT](/connectors/bank-of-canada-connector-to-chatgpt)

## What users are saying

## Every claim has a receipt.

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A3re: trusting AI

![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public)Nodari RizunFounder & CEO, Pürblack®

> _“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”_

C9re: one source of truth

![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public)Mark SimmonsCMO, Pürblack®

> _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_

E7re: getting time back

![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public)Nodari RizunFounder & CEO, Pürblack®

> _“We regained time. And time is the one resource that never comes back.”_

## Turn your Open Holidays Connector to ChatGPT data into business decisions

[Get started free](https://www.owox.com/app-signup)

## References

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Get started free](https://www.owox.com/app-signup)
- [AWS Athena Connector to ChatGPT](https://www.owox.com/connectors/aws-athena-connector-to-chatgpt) — /connectors/aws-athena-connector-to-chatgpt.md
- [AWS Redshift Connector to ChatGPT](https://www.owox.com/connectors/aws-redshift-connector-to-chatgpt) — /connectors/aws-redshift-connector-to-chatgpt.md
- [Bank of Canada Connector to ChatGPT](https://www.owox.com/connectors/bank-of-canada-connector-to-chatgpt) — /connectors/bank-of-canada-connector-to-chatgpt.md
