Free Open Exchange Rates to BigQuery Connector by OWOX: Take Full Control of Your Currency Data

Running financial analysis is one thing. But automating live currency data flows into BigQuery without hitting API limits, tool fees, or brittle pipelines? That’s where it gets tricky.

Forget CSV uploads, copy-paste hacks, or expensive ETL tools.

With this free, open-source connector from OWOX Data Marts, you can sync real-time exchange rate data from Open Exchange Rates directly into Google BigQuery – no code, no fees, just transparent, scalable FX data pipelines built for analysts.

Why We Made This Free Connector

Currency data powers everything from pricing models to international revenue reporting – but piping live exchange rates into BigQuery in a clean, analyst-ready format isn’t always straightforward.

At OWOX, we believe analysts and finance teams shouldn’t have to rely on clunky exports, overpriced ETL tools, or locked-down integrations just to access FX data. That’s why we built this free Open Exchange Rates to BigQuery connector as part of the OWOX Data Marts.

No subscriptions. No usage caps. Just full transparency and control over your currency data – streaming directly into BigQuery for modeling, enrichment, and automation.

Whether you’re aligning pricing to global markets, tracking rate shifts over time, or joining FX data with sales or spend pipelines, this connector keeps you in charge.

Join the Open-Source Movement

We’re not just releasing a free connector, we’re inviting you to help shape the future of data and marketing analytics tools.

At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source, giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and / or provide documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation; now it’s your turn to take it further.

Why Send Open Exchange Rates Data to BigQuery?

Exchange rate data is vital for accurate forecasting, budgeting, and multi-currency reporting. But Open Exchange Rates doesn’t offer a native integration with Google BigQuery, which means you're often stuck with fragmented workflows and manual effort.

❌ No direct pipeline to BigQuery
❌ CSV exports that don’t scale or automate
❌ No way to blend exchange rates with spend, sales, or marketing data in real time

This connector changes that.

✅ Automate exchange rate imports straight into your BigQuery tables
✅ Define your own start dates and target currencies
✅ Get clean, structured FX data ready for modeling, reporting, or joining with other datasets

Instead of wrestling with workarounds or rigid platforms, analysts can now pull live Open Exchange Rates data into BigQuery with full transparency and control, without writing a single line of code.

Why Choose the OWOX Connector for Open Exchange Rates to BigQuery

The OWOX connector gives you more than a simple data transfer–it offers full control over your exchange rate data directly in BigQuery. Unlike paid ETL platforms that limit access, enforce rigid schemas, or lock features behind premium tiers, this solution is fully open-source and runs in your own environment.

• Transparent by design – review and modify the script logic to suit your data model and analytics workflow
• Fast setup – configure your base currency, symbols, and historical range in just a few clicks
• Own your schema — define your destination table schema, assign clear field aliases, and adjust the structure to align with your reporting needs.
• 100% free – no usage fees, hidden limits, or tiered pricing. This connector is available free on GitHub as part of OWOX Data Marts.

Whether you’re feeding exchange rates into financial models, normalizing currency fields for eCommerce data, or building multi-market dashboards, the OWOX connector lets you automate Open Exchange Rates imports into BigQuery without compromise.

Explore More Free Connectors:
Already using Open Exchange Rates in BigQuery? Expand your workflow with these free, no-code integrations:
‍
Open Exchange Rates → Sheets
Microsoft Ads → BigQuery
Criteo Ads → BigQuery
LinkedIn Ads → BigQuery
‍
No subscriptions. No technical barriers. Just fast, flexible access to all your data.

How the Connector Works

We built the OWOX Open Exchange Rates to BigQuery connector to make currency data integration seamless – no paid tools, no CSVs, and no manual syncing. This Open Exchange Rates to BigQuery connector from OWOX Data Marts delivers what most tools don’t – full control without the complexity.

It’s built on an open-source framework you run yourself, so there’s no need for extra platforms, paid ETL services, or CSV workarounds.

Here’s how it works:

• Connects directly to the Open Exchange Rates API using your App ID, with no third-party intermediaries.
• Lets you set a custom start date and select specific currency symbols for targeted imports.
• Automatically sends both historical and current exchange rates into BigQuery for scalable storage and SQL-based analysis.
• Includes optional cleanup settings to manage table size and data retention based on your needs.

With transparent logic and flexible control, this connector delivers accurate exchange rate data into BigQuery, making it ideal for financial modeling, pricing strategy, multi-market dashboards, and more.

Step-by-Step: Import Open Exchange Rates Data to BigQuery with OWOX Data Marts

Set up a fully self-managed, SaaS-free pipeline to import Open Exchange Rates data directly into BigQuery using the OWOX Data Marts and a local server.

Step 1: Install Node.js and OWOX CLI ( ~2 min)

To run OWOX Data Mart locally, you’ll need to install Node.js and the OWOX CLI. This setup allows you to start a local server and work with the OWOX Data Marts effectively.

To get started, install the LTS version of Node.js from nodejs.org and use a version manager like nvm or nvm-windows to avoid permission issues. Once Node.js is set up, you can install the OWOX CLI globally and run ‘owox serve’ to launch the local server.

💡 For detailed setup instructions and troubleshooting, check the official documentation.

Step 2: Connect Google BigQuery and Set Up Your Data Mart ( ~3 min)

Set up BigQuery as your destination and link it to a new Open Exchange Rates data mart in OWOX.

1.  Open your browser and go to http://localhost:3000.

💡 Follow our guide, where you’ll find easy-to-follow instructions on how to configure your storage in OWOX Data Marts.

2. Create your Service Account JSON Key.

• Follow our guide to create your service account JSON Key.

3. Paste the entire contents into the ‘OWOX Service Account JSON Field’

• Don’t forget to click Save

4. Create your first Data Mart
   
   • Once storage is added, click on the Data Mart Tab, then on ‘New Data Mart’

• Now, create the Data Mart, name the title as ‘Open Exchange Rates Data’, as the data source
• Choose the storage named ‘Open Exchange Rates Storage’ you just created
• Click ‘Create Data Mart’.

Now we will do the Data Setup

5. Set up your Data Mart
   
   • Go to the Data Setup Tab and then select Connector

• Click on Setup Connector and Choose Open Exchange Rates Connector

Step 3: Get the Open Exchange Rates App ID ( ~1 min)

To start importing data, you first need to generate an App ID from Open Exchange Rates to authorize the connector.

Prerequisites

• An Open Exchange Rates account (free or paid)
• Developer access to generate an App ID.
• Access to your BigQuery project where the data will be stored.

Steps to Obtain Credentials

1. Log in to Your Account

• Visit  https://openexchangerates.org and sign in or create an account.

2. Go to the App IDs Section

•  Navigate to the Integration → App IDs  section from the dashboard.

3. Create a New App ID

• Enter a name for your app and click  Generate New App ID.

4. Copy Your App ID

•  Once generated, copy the App ID, as you’ll use it when setting up the connector in BigQuery.

Security Notes

• Keep your App ID secure
• Don’t share credentials
• For production environments, always implement secure token refresh logic

Step 4: Configure Open Exchange Rates Connector and Run Your First Import ( ~2 min)

Now that you’ve retrieved your Open Exchange Rates App ID, it’s time to configure the connector in OWOX.

1. Paste the App ID.

2. Start Date:
   
   • Set the reporting start date (e.g., 2025-08-01). This determines how far back data will be fetched.

• Currency Symbols: Set the currency symbol (e.g., GBP), used to represent monetary values in the fetched data.

3. Scrolling down reveals additional parameter fields. For the first run, they’re optional, and you can adjust them anytime later if needed.
4. Click Next‍‍
5. Endpoint: Choose the following valid endpoint
   • Historical exchange rates data

6. Choose Fields: 
   
   • Select all available fields or choose specific metrics like date, base, rate, and currency based on your reporting needs.

7. Name the Dataset
   
   • Enter the BigQuery dataset name where the imported data should be stored.

Note: If the dataset doesn't exist, OWOX will create it automatically during the import process.

8. Click Finish

9. In the Data Setup Tab. Click 'Save'.

10. Click 'Publish Data Mart'.

11. Click 'Manual Run' button or use the 3-dot menu.

12. A configuration panel will appear to choose a Run Type. Select Backfill or Incremental Load. Then add the required start and end dates, then click Run to load the data. 

Please Note: If you are setting up this connector for the first time, you need to go with the Backfill Run Type.

‍

13. Go to 'Run History' and see the message: 'Success'.

Step 5: Schedule Automated Imports ( ~1 min)

Set up a trigger to pull data on a recurring schedule.

1. Go to the 'Triggers' tab in the new Data Mart
   
   • Click 'Add Trigger'.

2. Configure.

• Trigger Type: Connector Run
• Schedule Settings: Daily / Weekly / Monthly / Interval
• Time Settings: hour, minute, second
• Days of the week
• Time zone

3. Click 'Create Trigger'. Your data will now refresh automatically.

4. The trigger is now active and scheduled to run automatically on the defined days and at the defined time.

What’s Next?

The free Open Exchange Rates to BigQuery connector in OWOX Data Marts advances our mission to keep data ownership simple, transparent, and accessible to everyone.

Explore more resources:
🔗 More free connectors – like Facebook Ads and Twitter Ads to BigQuery, designed for flexible data ownership
🎥 Guided video tutorials – to walk you through setup, configuration, and custom use cases
📊 Ready-made dashboards – deliver your BigQuery data directly into Google Sheets and Looker Studio, so teams get insights faster with less effort.

Explore the full list of tools on our GitHub repo, drop us a ⭐ star, and help shape the future of open analytics with OWOX Connectors.