---
title: "Open Holidays to Google BigQuery Connector | OWOX"
canonical: "https://www.owox.com/connectors/open-holidays-connector-to-google-bigquery"
updated: "2026-09-17"
---

# Open Holidays Connector to Google BigQuery

Own your Open Holidays data in Google BigQuery with OWOX Data Marts. Collect granular, analytics-ready Open Holidays data into Google BigQuery, control schema and refresh logic, and reuse the data across BI tools and AI Insights.

[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 |

## Related connectors

[Bank of Canada Connector to Google BigQuery](/connectors/bank-of-canada-connector-to-google-bigquery)

[Criteo Ads to Google BigQuery Connector](/connectors/free-criteo-ads-connector-to-google-bigquery)

[Facebook Ads to Google BigQuery Connector](/connectors/free-facebook-ads-connector-to-google-bigquery)

## 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 Google BigQuery 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)
- [Bank of Canada Connector to Google BigQuery](https://www.owox.com/connectors/bank-of-canada-connector-to-google-bigquery) — /connectors/bank-of-canada-connector-to-google-bigquery.md
- [Criteo Ads to Google BigQuery Connector](https://www.owox.com/connectors/free-criteo-ads-connector-to-google-bigquery) — /connectors/free-criteo-ads-connector-to-google-bigquery.md
- [Facebook Ads to Google BigQuery Connector](https://www.owox.com/connectors/free-facebook-ads-connector-to-google-bigquery) — /connectors/free-facebook-ads-connector-to-google-bigquery.md