Skip to content
Book a demoStart free
Connectors

Open Exchange Rates connector

Set up the Open Exchange Rates connector in Kaivo: authentication, configuration, the 1 BigQuery tables it syncs, and answers to common questions.

Open Exchange Rates connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Open Exchange Rates data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your payment and finance data instead of moving it.

Sync your Open Exchange Rates currency rates into BigQuery with Kaivo to convert amounts and track foreign exchange rates over time.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Open Exchange Rates connector

Section titled “Getting started with the Open Exchange Rates connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Open Exchange Rates account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your App ID.

Field Description
App ID
Your Open Exchange Rates App ID. Find it on your account page at openexchangerates.org.

|

Configuring the Open Exchange Rates connector

Section titled “Configuring the Open Exchange Rates connector”

When you set up the connector, you provide:

Field Description
Base Currency
The base currency for exchange rates as a 3-letter code (e.g. USD, EUR). Only modifiable on paid plans.

| | Start Date |

Any data before this date will not be fetched.

|

Tables and columns synced from Open Exchange Rates

Section titled “Tables and columns synced from Open Exchange Rates”

Kaivo syncs 1 table from Open Exchange Rates into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

open_exchange_rates (176 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
base STRING The base currency against which exchange rates are provided.
disclaimer STRING Information about the usage rights or restrictions related to the provided data.
license STRING The type of license under which the exchange rate data is made available.
rates__aed FLOAT64 United Arab Emirates Dirham
rates__afn FLOAT64 Afghan Afghani
rates__all FLOAT64 Albanian Lek
rates__amd FLOAT64 Armenian Dram
rates__ang FLOAT64 Netherlands Antillean Guilder
rates__aoa FLOAT64 Angolan Kwanza
rates__ars FLOAT64 Argentine Peso
rates__aud FLOAT64 Australian Dollar
rates__awg FLOAT64 Aruban Florin
rates__azn FLOAT64 Azerbaijani Manat
rates__bam FLOAT64 Bosnia-Herzegovina Convertible Mark
rates__bbd FLOAT64 Barbadian Dollar
rates__bdt FLOAT64 Bangladeshi Taka
rates__bgn FLOAT64 Bulgarian Lev
rates__bhd FLOAT64 Bahraini Dinar
rates__bif FLOAT64 Burundian Franc
rates__bmd FLOAT64 Bermudian Dollar
rates__bnd FLOAT64 Brunei Dollar
rates__bob FLOAT64 Bolivian Boliviano
rates__brl FLOAT64 Brazilian Real
rates__bsd FLOAT64 Bahamian Dollar
rates__btc FLOAT64 Bitcoin
rates__btn FLOAT64 Bhutanese Ngultrum
rates__bwp FLOAT64 Botswana Pula
rates__byn FLOAT64 Belarusian Ruble
rates__bzd FLOAT64 Belize Dollar
rates__cad FLOAT64 Canadian Dollar
rates__cdf FLOAT64 Congolese Franc
rates__chf FLOAT64 Swiss Franc
rates__clf FLOAT64 Chilean Unit of Account (UF)
rates__clp FLOAT64 Chilean Peso
rates__cnh FLOAT64 Chinese Yuan (offshore)
rates__cny FLOAT64 Chinese Yuan
rates__cop FLOAT64 Colombian Peso
rates__crc FLOAT64 Costa Rican Colón
rates__cuc FLOAT64 Cuban Convertible Peso
rates__cup FLOAT64 Cuban Peso
rates__cve FLOAT64 Cape Verdean Escudo
rates__czk FLOAT64 Czech Koruna
rates__djf FLOAT64 Djiboutian Franc
rates__dkk FLOAT64 Danish Krone
rates__dop FLOAT64 Dominican Peso
rates__dzd FLOAT64 Algerian Dinar
rates__egp FLOAT64 Egyptian Pound
rates__ern FLOAT64 Eritrean Nakfa
rates__etb FLOAT64 Ethiopian Birr
rates__eur FLOAT64 Euro
rates__fjd FLOAT64 Fijian Dollar
rates__fkp FLOAT64 Falkland Islands Pound
rates__gbp FLOAT64 British Pound Sterling
rates__gel FLOAT64 Georgian Lari
rates__ggp FLOAT64 Guernsey Pound
rates__ghs FLOAT64 Ghanaian Cedi
rates__gip FLOAT64 Gibraltar Pound
rates__gmd FLOAT64 Gambian Dalasi
rates__gnf FLOAT64 Guinean Franc
rates__gtq FLOAT64 Guatemalan Quetzal
rates__gyd FLOAT64 Guyanese Dollar
rates__hkd FLOAT64 Hong Kong Dollar
rates__hnl FLOAT64 Honduran Lempira
rates__hrk FLOAT64 Croatian Kuna
rates__htg FLOAT64 Haitian Gourde
rates__huf FLOAT64 Hungarian Forint
rates__idr FLOAT64 Indonesian Rupiah
rates__ils FLOAT64 Israeli New Sheqel
rates__imp FLOAT64 Isle of Man Pound
rates__inr FLOAT64 Indian Rupee
rates__iqd FLOAT64 Iraqi Dinar
rates__irr FLOAT64 Iranian Rial
rates__isk FLOAT64 Icelandic Króna
rates__jep FLOAT64 Jersey Pound
rates__jmd FLOAT64 Jamaican Dollar
rates__jod FLOAT64 Jordanian Dinar
rates__jpy FLOAT64 Japanese Yen
rates__kes FLOAT64 Kenyan Shilling
rates__kgs FLOAT64 Kyrgyzstani Som
rates__khr FLOAT64 Cambodian Riel
rates__kmf FLOAT64 Comorian Franc
rates__kpw FLOAT64 North Korean Won
rates__krw FLOAT64 South Korean Won
rates__kwd FLOAT64 Kuwaiti Dinar
rates__kyd FLOAT64 Cayman Islands Dollar
rates__kzt FLOAT64 Kazakhstani Tenge
rates__lak FLOAT64 Lao Kip
rates__lbp FLOAT64 Lebanese Pound
rates__lkr FLOAT64 Sri Lankan Rupee
rates__lrd FLOAT64 Liberian Dollar
rates__lsl FLOAT64 Lesotho Loti
rates__lyd FLOAT64 Libyan Dinar
rates__mad FLOAT64 Moroccan Dirham
rates__mdl FLOAT64 Moldovan Leu
rates__mga FLOAT64 Malagasy Ariary
rates__mkd FLOAT64 Macedonian Denar
rates__mmk FLOAT64 Myanmar Kyat
rates__mnt FLOAT64 Mongolian Tugrik
rates__mop FLOAT64 Macanese Pataca
rates__mro FLOAT64 Mauritanian Ouguiya
rates__mru FLOAT64 Mauritanian Ouguiya
rates__mur FLOAT64 Mauritian Rupee
rates__mvr FLOAT64 Maldivian Rufiyaa
rates__mwk FLOAT64 Malawian Kwacha
rates__mxn FLOAT64 Mexican Peso
rates__myr FLOAT64 Malaysian Ringgit
rates__mzn FLOAT64 Mozambican Metical
rates__nad FLOAT64 Namibian Dollar
rates__ngn FLOAT64 Nigerian Naira
rates__nio FLOAT64 Nicaraguan Córdoba
rates__nok FLOAT64 Norwegian Krone
rates__npr FLOAT64 Nepalese Rupee
rates__nzd FLOAT64 New Zealand Dollar
rates__omr FLOAT64 Omani Rial
rates__pab FLOAT64 Panamanian Balboa
rates__pen FLOAT64 Peruvian Nuevo Sol
rates__pgk FLOAT64 Papua New Guinean Kina
rates__php FLOAT64 Philippine Peso
rates__pkr FLOAT64 Pakistani Rupee
rates__pln FLOAT64 Polish Zloty
rates__pyg FLOAT64 Paraguayan Guarani
rates__qar FLOAT64 Qatari Riyal
rates__ron FLOAT64 Romanian Leu
rates__rsd FLOAT64 Serbian Dinar
rates__rub FLOAT64 Russian Ruble
rates__rwf FLOAT64 Rwandan Franc
rates__sar FLOAT64 Saudi Riyal
rates__sbd FLOAT64 Solomon Islands Dollar
rates__scr FLOAT64 Seychellois Rupee
rates__sdg FLOAT64 Sudanese Pound
rates__sek FLOAT64 Swedish Krona
rates__sgd FLOAT64 Singapore Dollar
rates__shp FLOAT64 Saint Helena Pound
rates__sll FLOAT64 Sierra Leonean Leone
rates__sos FLOAT64 Somali Shilling
rates__srd FLOAT64 Surinamese Dollar
rates__ssp FLOAT64 South Sudanese Pound
rates__std FLOAT64 São Tomé and Príncipe Dobra
rates__stn FLOAT64 São Tomé and Príncipe Dobra
rates__svc FLOAT64 Salvadoran Colón
rates__syp FLOAT64 Syrian Pound
rates__szl FLOAT64 Swazi Lilangeni
rates__thb FLOAT64 Thai Baht
rates__tjs FLOAT64 Tajikistani Somoni
rates__tmt FLOAT64 Turkmenistan Manat
rates__tnd FLOAT64 Tunisian Dinar
rates__top FLOAT64 Tongan Pa’anga
rates__try FLOAT64 Turkish Lira
rates__ttd FLOAT64 Trinidad and Tobago Dollar
rates__twd FLOAT64 New Taiwan Dollar
rates__tzs FLOAT64 Tanzanian Shilling
rates__uah FLOAT64 Ukrainian Hryvnia
rates__ugx FLOAT64 Ugandan Shilling
rates__usd FLOAT64 United States Dollar
rates__uyu FLOAT64 Uruguayan Peso
rates__uzs FLOAT64 Uzbekistan Som
rates__ves FLOAT64 Venezuelan Bolívar
rates__vnd FLOAT64 Vietnamese Dong
rates__vuv FLOAT64 Vanuatu Vatu
rates__wst FLOAT64 Samoan Tala
rates__xaf FLOAT64 Central African CFA Franc
rates__xag FLOAT64 Silver (ounce)
rates__xau FLOAT64 Gold (ounce)
rates__xcd FLOAT64 East Caribbean Dollar
rates__xdr FLOAT64 Special Drawing Rights (International Monetary Fund)
rates__xof FLOAT64 West African CFA Franc
rates__xpd FLOAT64 Palladium (ounce)
rates__xpf FLOAT64 CFP Franc
rates__xpt FLOAT64 Platinum (ounce)
rates__yer FLOAT64 Yemeni Rial
rates__zar FLOAT64 South African Rand
rates__zmw FLOAT64 Zambian Kwacha
rates__zwl FLOAT64 Zimbabwean Dollar
timestamp INT64 The UNIX timestamp indicating when the exchange rates were last updated.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Open Exchange Rates supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Open Exchange Rates?

Section titled “How long does the initial sync take for Open Exchange Rates?”

It depends on how much history is in your Open Exchange Rates account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Open Exchange Rates’s schema changes?

Section titled “What happens when Open Exchange Rates’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Open Exchange Rates, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Open Exchange Rates instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Open Exchange Rates connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Open Exchange Rates data

Section titled “Common use cases for Open Exchange Rates data”

Use rates to convert transactions into a single reporting currency.

Track rates by timestamp to see how currency pairs move over time.

Join rates to your sales or expense data to report consistently across markets.

Analyse rate changes against your currency positions to understand exposure.

Use Open Exchange Rates data in your AI and BI tools

Section titled “Use Open Exchange Rates data in your AI and BI tools”

Once Open Exchange Rates data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Open Exchange Rates data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Open Exchange Rates connector pricing and plan details.