Ask Claude about Bank of Canada data
Load official Bank of Canada rates into your data warehouse first, let your data analyst join them to each visit's date and currency, then ask Claude about clinic revenue in Canadian dollars. Claude reads governed Data Marts through OWOX MCP, not a pasted rate table.
Bank of CanadaConnectedExchange Rates
ClaudeDateLabelRateDaily 09:00A rate table pasted into Claude shows how the Bank of Canada rate moved, not what that did to your revenue.
Paste this into your AI assistant. It loads Bank of Canada rates into your data warehouse with OWOX Data Marts, joins them to your visits, and gives Claude the governed Data Mart through the OWOX MCP server.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/bank-of-canada-connector-to-claude.md. The task: load Bank of Canada daily rates into my data warehouse and connect Claude to the Data Mart, then show this year's low, high and average rate by month and my revenue in Canadian dollars. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Bank of Canada Endpoints
1 Bank of Canada endpoints you can import. Each lands in its own table in your data warehouse.
Why Claude needs your data warehouse, not a pasted rate table
Claude reading the official rates directly sees a rate table. It does not see which rate each clinic visit should use, because visits and rates live in different systems. The answer is better when it comes from a warehouse, where your data analyst joins the daily rates to every visit billed in USD or CAD.
- Bank of Canada publishes daily official rates, not what they mean for your revenue
- Your data analyst restates the local revenue of USD and CAD visits in one currency and controls the result
- Claude answers from a governed Data Mart, with one official rate per day
Bank of CanadaOfficial FX ratesClaude
Data warehouseJoined by idStep 1: Load Bank of Canada into your data warehouse first
Create a Data Mart with Bank of Canada as the source and choose where the data lands. It works with any popular data warehouse.
- One endpoint, Exchange Rates, with three fields: date, label and rate
- The source needs no credentials
- Open the Bank of Canada connector for your data warehouse below
Bank of Can…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksbank_of_canada.exchange_ratesStep 2: Link Bank of Canada rates to visits
In your data warehouse your data analyst joins the official rate table to each visit's date and currency, so local revenue can be restated in Canadian dollars. The model supplies the visits and the measures.
- The rate table sits beside Visits
- They join on visit date and currency plus CAD, so a USD visit matches USDCAD; CAD visits take a rate of 1
- Measures such as revenue_per_visit are defined once, on the stored USD amount
Bank of CanadaExchange RatesStep 3: Connect Claude to your data with OWOX MCP
In Claude, open Settings, then Connectors, and add the OWOX MCP server. Claude then sees the Data Marts you published, and only those.
- The OWOX MCP server lists the Data Marts it can read
- Only published Data Marts are visible, nothing else in your data warehouse
ClaudeConnectorsOWOX MCPAddConnectedStep 4: Ask Claude for revenue in one currency
Ask in plain words, for example revenue per visit by month. Claude finds the Data Mart that answers it, runs the query and answers with measures your data analyst defined.
- Revenue comes from Visits in your data warehouse
- Your data analyst can check the stored rate of any visit against the official one for that day
ClaudeShow revenue_per_visit by monthget_relevant_data_marts_by_promptquery_data_martrevenue_per_visitattended_visitsStep 5: Export the answer when you need a file
Optional: in one click, export the answer or its source data to Google Sheets, CSV or XLS to check it or share it.
- The export carries the same governed numbers as the answer
- Share it with a colleague who does not use Claude
Google SheetsCSVXLSOne click
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.36.0Support MCP protocol 2026-07-28 and alert on compatibility failures
- 0.36.0Start a connector run without expanding the Input Source card
- 0.35.0Destinations tab now promotes connecting an AI assistant alongside your existing destinations
Why OWOX for Bank of Canada in Claude
Letting Claude call the Bank of Canada API gets a number into a chat. OWOX also keeps the data yours and defined once, so a clinic's answer is one you can check.
- You own the data. It lands in your own data warehouse, in tables you control.
- Official daily rates. Bank of Canada rates need no account or key and land in your data warehouse as a plain table.
- Canadian dollars on request. Local revenue is restated against the official daily rate, so Claude gives one answer for one date.
- Answers you can trace. You can see which Data Mart an answer came from, and one click exports its source data.
- Maintained for you. Bank of Canada connector upkeep is on OWOX, not on a script you wrote.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.