Collect Bank of Canada exchange rates into your warehouse
The Bank of Canada connector loads official daily exchange rates into your own warehouse, so multi-currency revenue and spend sit on one basis in every report.
Available connectors from Bank of Canada
Available connectors from Bank of Canada
- Bank of Canada Connector to ChatGPT1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to Claude1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to AWS Athena1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to AWS Redshift1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to Databricks1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to Google BigQuery1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to Snowflake1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to API1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to Data Studio1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to Google Sheets1 endpoint3 fieldsExchange Rates
- Bank of Canada Connector to Microsoft Excel1 endpoint3 fieldsExchange Rates
- Bank of Canada Insights to Email1 endpoint3 fieldsExchange Rates
- Bank of Canada Insights to Google Chat1 endpoint3 fieldsExchange Rates
- Bank of Canada Insights to Microsoft Teams1 endpoint3 fieldsExchange Rates
- Bank of Canada Insights to Slack1 endpoint3 fieldsExchange Rates
Bank of Canada Endpoints
1 Bank of Canada endpoints you can import. Each lands in its own table in your warehouse.
Exchange Rates
Daily foreign exchange rates from Bank of Canada.
3 fieldsTime series
Bank of Canada Exchange Rates schema
3 fieldsTime seriesSchema on GitHubbank_of_canada_exchange_rates
Daily foreign exchange rates from Bank of Canada.
| Field | Type | Description |
|---|---|---|
date | DATE | The date for which the exchange rate was recorded. |
label | STRING | The currency code (e.g., USD, EUR, GBP). |
rate | NUMBER | The exchange rate value. |
Why Collect Bank of Canada Data Into Your Warehouse With OWOX?
A revenue column in three currencies does not add up until someone converts it, and a conversion typed into a spreadsheet drifts from the next one. The Bank of Canada publishes official exchange rates. OWOX loads them into your warehouse so every conversion in every report uses the same rate table.
Collect to your warehouse
The rates land in your warehouse, not in OWOX, so you own them. Every connector is included in every OWOX Cloud plan, with no per-connector bill.
Zero-maintenance syncs
The connector is open source under the MIT license, so you can read the code. A Connector Trigger runs it on the schedule you set.
Full-funnel joins
Join the rate table to orders, ad spend or finance data in a Data Mart. The SQL behind every join stays visible.
R01 · Collect
Collect All Your Bank of Canada Data With Zero Engineering
The connector has one endpoint, Exchange Rates, which carries the daily foreign exchange rates from the Bank of Canada. It is a time series and lands in a table named bank_of_canada_exchange_rates. The table has three fields.
| Field | Type | What it holds |
|---|---|---|
| date | DATE | The date the rate was recorded |
| label | STRING | The currency code, such as USD, EUR or GBP |
| rate | NUMBER | The exchange rate value |
The source needs no credentials, so there is no token or service account to set up. To start:
- Add a storage to receive the data: Google BigQuery, Snowflake, AWS Redshift, AWS Athena or Databricks.
- Create a Connector Data Mart and choose Bank of Canada as the platform.
- Publish the Data Mart and run it for the first import.
- Add a Connector Trigger to schedule recurring imports.
The connector documentation has the full setup guide.
R02 · Report
Build Reports With Bank of Canada Data That Everyone Trusts
Once the rates are in your warehouse, they behave like any other table you own.
- Join
labelanddateto your orders or ad spend, and report revenue in one currency. - Define the conversion once in a Data Mart. Every report built on it uses the same rate.
- Pair the rates with Data Marts built from ad platforms or a shop, so spend and revenue in different currencies compare on one basis.
- Keep the SQL behind each number one click away, so a finance question has an answer you can show.
Analysts own the definition, and business users get the converted numbers in the tools they already open.
R03 · Why OWOX
Deliver Bank of Canada Data to the Tools Your Team Uses
A Report delivers one Data Mart to one destination, and each Data Mart can feed many destinations.
- Push mode: OWOX writes the data on a manual or scheduled run. Google Sheets, email, Slack, Microsoft Teams and Google Chat work this way.
- Pull mode: the tool asks OWOX for the data when a user refreshes it. Data Studio and Microsoft Excel work this way.
- AI assistants such as Claude and ChatGPT read the Data Mart, not the raw tables, so answers use your definitions.
Why Use OWOX Connectors to Collect Your Bank of Canada Data?
One basis for every currency
Multi-currency revenue and spend are reported on one basis, from one governed rate table.
Your data stays yours
The rates sit in a warehouse you own. OWOX does not keep a copy.
No credentials to manage
The source is public reference data, so nothing secret sits in the connector.
Scheduled, not manual
A Connector Trigger refreshes the table on your schedule, and nobody pastes rates into a sheet.
Readable by anyone
The connector code is open source, so you can see exactly what it fetches.
Define once, reuse everywhere
One Data Mart with the conversion feeds Sheets, Excel, Data Studio and AI assistants.
Fewer reconciliation threads
When the numbers disagree across reports, a shared rate table removes one common cause.
Free of per-connector cost
All connectors are included in every OWOX Cloud plan.
Not testimonials. Comment threads.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
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.”
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.”
Nodari RizunFounder & CEO, Pürblack®“We regained time. And time is the one resource that never comes back.”
Start collecting Bank of Canada exchange rates
Add the connector, pick the fields, set a schedule. The source needs no credentials.
- Internal OWOX data as of 2026-10-02
- G2 reviews of OWOX
- npm installs stat