--- title: "Open Exchange Rates to BigQuery with OWOX Data Marts" canonical: "https://www.owox.com/blog/articles/free-open-exchange-rates-to-bigquery-connector" updated: "2026-10-26" --- # How to load Open Exchange Rates into BigQuery with OWOX Data Marts Open Exchange Rates to Google BigQuery in OWOX Data Marts: copy an App ID, create a Data Mart, choose the Open Exchange Rates connector, paste the App ID and publish. Then add a trigger and the rates refresh on their own. [Data Integration](/blog/topics/data-integration) · Updated October 26, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 3 min read ![How to load Open Exchange Rates into BigQuery with OWOX Data Marts](https://cdn.owox.com/www/content-marketing-article/free-open-exchange-rates-to-bigquery-connector/thumbnail/1-09htrc.png/public) Ad platforms bill in different currencies, and a spend report that adds dollars to euros is wrong before anyone reads it. The fix is a table of daily exchange rates in Google BigQuery that your SQL can join to. [OWOX Data Marts](https://www.owox.com/app-signup) loads that table from Open Exchange Rates and keeps it current. You need one App ID, which Open Exchange Rates gives out on its free plan. This guide walks through the setup on OWOX Cloud. ## What you need * **An OWOX Cloud account.** [Sign up](https://www.owox.com/app-signup) if you do not have one. * **A Google BigQuery storage in OWOX Data Marts.** Add it under Storages, or create it while you set up the Data Mart. More on [Google BigQuery as a storage](/data-storages/google-bigquery). * **An Open Exchange Rates account.** The free plan is enough to start. ## Step 1: Get the App ID Sign in or sign up at [openexchangerates.org](https://openexchangerates.org). ![Homepage of Open Exchange Rates showcasing its currency data API and sign-up options.](https://cdn.owox.com/www/webflow/688366f3e35f85d85eeea582_AD_4nXdCoYbMz7KxB4eijHRWarXmTD3piYLFEmPS1fjLU7k9RKV8jAbGDNyu_SU-bnzJ9QWymlTR17QDS9zapVbZreXuwoVwkQNqlWISBP4Hjf1e8tPKpeVABCFciAv-Cn3CQCTzuEfY.png/public) Open **App IDs** in the left-hand menu. ![Open Exchange Rates dashboard with the “App IDs” section highlighted in the left-hand navigation menu.](https://cdn.owox.com/www/webflow/688366f3e35f85d85eeea563_AD_4nXcxYw6RkkB9Oif3nVZoPG6fYOiNCY4zdYqlhx4T6WxJFT7vW5wEsd6QwM_bz8UeC3-sRVGwOTKanBf82HqBrTb0AmluYTTmG-wuOCnVXzzAvmfaw1EVSGok4yRdZBOKZV04zHAx1A.png/public) Enter a name and click **Generate New App ID**. Copy the App ID. ![Open Exchange Rates App IDs page showing the interface to enter a name and generate a new App ID, with one existing App ID already listed.](https://cdn.owox.com/www/webflow/688366f4e35f85d85eeea59f_AD_4nXcRfjeaKLImJ2PQbg1vnQoxaUu2o03B0B65xRRE67Fc1ld_NevgzR242uxTFrSptexqUKcj0nqZK0dGIMi_MBmjdrYLDYMGu8hSUmg8dCnRgT4NpjspGbo0XbRyFc1c11oKtYIpAA.png/public) ## The Turning Point OWOX Data Marts See your first report built in real time. _15 minutes._ 1. Connect your data warehouse 2. Pick your metrics 3. Get a live Google Sheets report In the time it takes to write a ticket. Then imagine never writing that ticket again. [Book a Demo](/book-a-call) We'll use your actual use case ## Step 2: Create the Data Mart Click **New Data Mart**, give it a title, choose your Google BigQuery storage and click **Create Data Mart**. If you have no storage yet, pick **Create new storage** in the same dropdown. ![The Create Data Mart form in OWOX Data Marts with a title and a Google BigQuery storage selected](https://cdn.owox.com/www/content-marketing-article/free-open-exchange-rates-to-bigquery-connector/screens/1.png/public) ## Step 3: Choose the Open Exchange Rates connector and enter the credentials On the **Data Setup** tab, set **Input Source** to **Connector** and click **Setup Connector**. Choose **Open Exchange Rates** in the list and click **Next**. Fill in the settings: * **App ID**: the one you just copied. * **Currency Symbols**: optional. Enter the currency symbols you need, such as GBP. The [list of symbols](https://docs.openexchangerates.org/reference/supported-currencies) is in the Open Exchange Rates documentation. Rates are quoted against the US dollar by default. ## Step 4: Choose what to load There is one thing to load here: historical exchange rates, one row per currency per day. Keep the default fields or add more. The key fields stay selected. Name the dataset and the table. Both are created on the first run if they do not exist yet. Click **Save**. ## Step 5: Publish and run Click **Publish & Run Data Mart**. The first run loads rates from the first day of the previous month. To load older history, use **Manual Run** on the same screen and choose the dates. **Run History** shows every run and its status. ![The Manual Run dialog in OWOX Data Marts with Backfill (custom period) selected and empty Start Date and End Date fields](https://cdn.owox.com/www/content-marketing-article/free-open-exchange-rates-to-bigquery-connector/screens/2.png/public) ## Step 6: Keep it fresh Open **Triggers**, add a trigger, choose **Connector Run** and set how often it runs: daily at a time and time zone you pick, weekdays, hourly or every few hours. Click **Create trigger**. From here the table updates on its own. ## What to do with the data Join the rates to your spend tables on date and currency, and convert every amount to one currency before you sum it. With rates in the same dataset as your ad data, that is one join in the query that builds your report. OWOX Data Marts loads the rates and publishes what you build on them. The conversion SQL stays yours, so you decide which rate applies to which day. ## Not on BigQuery? The same connector loads into the other [data storages](/data-storages) OWOX Data Marts supports: [Snowflake](/connectors/free-open-exchange-rates-connector-to-snowflake), [AWS Redshift](/connectors/free-open-exchange-rates-connector-to-aws-redshift), [AWS Athena](/connectors/free-open-exchange-rates-connector-to-aws-athena) and [Databricks](/connectors/free-open-exchange-rates-connector-to-databricks). OWOX Data Marts is also [open source](https://github.com/OWOX/owox-data-marts). If you run it yourself, the same App ID works. ## Your New Normal Turn your data into decisions. Governed data marts give you the clean foundation ML needs to actually work. * No AI hallucinations * Analyst-governed definitions * Every number traces to SQL [Get started free](https://www.owox.com/app-signup) ## FAQ ## Frequently Asked Questions Is an Open Exchange Rates App ID free? Open Exchange Rates has a free plan, and its App ID is enough to start loading rates. Limits and paid plans are listed on the Open Exchange Rates site. Which currencies are loaded? Enter the symbols you need in the Currency Symbols setting, such as GBP. The list of supported symbols is in the Open Exchange Rates documentation. Is the Open Exchange Rates to BigQuery connector free? The connector is open source and free to run yourself with the open-source edition of OWOX Data Marts. You pay Google for BigQuery storage and queries. The same connector is available on OWOX Cloud, where there is no server to maintain. Where does the data get stored in BigQuery? In the dataset and table you name in the last setup step. Both are created on the first run if they do not exist yet. Is the data import limited to USD as the base currency? USD is the default base currency. Which base currencies you can use depends on your Open Exchange Rates plan. You can import conversion rates to any supported currency. How often do the exchange rates refresh? As often as the trigger you add on the Triggers tab: daily at a time you choose, on weekdays, hourly or every few hours. You can also start a run by hand at any time with Manual Run. ## Who wrote this ![Vadym Kramarenko](https://cdn.owox.com/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public) [Vadym Kramarenko](/team/vadym-kramarenko) Growth Marketing Manager Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks. [LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko) [Data Integration](/blog/topics/data-integration) ## Related articles [Google BigQuery · How to Load Data into BigQuery: Every Method and When to Use It · October 6, 2026](/blog/articles/loading-data-into-bigquery) [Data Integration · CRM and Digital Marketing Data Integration: A Practical Guide · September 30, 2026](/blog/articles/crm-and-online-data-integration-guide) [Data Integration · How to Connect Criteo Ads to BigQuery with OWOX Data Marts · October 26, 2026](/blog/articles/free-criteo-ads-to-bigquery-connector) [See all articles →](/blog/articles) ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Schedule a meeting ## Schedule in person meeting at Data Outpost San Francisco You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Links 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. - [Data Integration](https://www.owox.com/blog/topics/data-integration) — /blog/topics/data-integration.md - [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md - [OWOX Data Marts](https://www.owox.com/app-signup) - [Google BigQuery as a storage](https://www.owox.com/data-storages/google-bigquery) — /data-storages/google-bigquery.md - [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md - [data storages](https://www.owox.com/data-storages) — /data-storages.md - [Snowflake](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-snowflake) — /connectors/free-open-exchange-rates-connector-to-snowflake.md - [AWS Redshift](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-aws-redshift) — /connectors/free-open-exchange-rates-connector-to-aws-redshift.md - [AWS Athena](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-aws-athena) — /connectors/free-open-exchange-rates-connector-to-aws-athena.md - [Databricks](https://www.owox.com/connectors/free-open-exchange-rates-connector-to-databricks) — /connectors/free-open-exchange-rates-connector-to-databricks.md - [Google BigQuery · How to Load Data into BigQuery: Every Method and When to Use It · October 6, 2026](https://www.owox.com/blog/articles/loading-data-into-bigquery) — /blog/articles/loading-data-into-bigquery.md - [Data Integration · CRM and Digital Marketing Data Integration: A Practical Guide · September 30,…](https://www.owox.com/blog/articles/crm-and-online-data-integration-guide) — /blog/articles/crm-and-online-data-integration-guide.md - [Data Integration · How to Connect Criteo Ads to BigQuery with OWOX Data Marts · October 26, 2026](https://www.owox.com/blog/articles/free-criteo-ads-to-bigquery-connector) — /blog/articles/free-criteo-ads-to-bigquery-connector.md - [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md