Email Bank of Canada reports to your team on a schedule
Load Bank of Canada into your data warehouse first, link it to the rest of your data with SQL keys, then send the official rate in the inbox of whoever signs off the invoices. The email comes from your source of truth, not from a hand-built export.
Bank of CanadaConnectedExchange Rates
EmailDateLabelRateDaily 09:00Whoever signs off invoices needs the official Bank of Canada rate, and today it arrives typed by hand into an email.
Paste this into your AI assistant. It loads Bank of Canada rates into your data warehouse with OWOX Data Marts and schedules an email from that Data Mart, so the rate comes from your source of truth.
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-insights-to-email.md. The task: email the people who sign off invoices a weekly report from my Bank of Canada Data Mart: the official rate for each day, the invoices it converts, and a short note on how the rate moved. 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 Bank of Canada does not go straight to email
Bank of Canada publishes the official rate for each currency, not what that rate does to your revenue. An email built straight from the source sends the source's own numbers to an inbox with nothing to check them against; a scheduled export is no better, because it does not tie them to the rest of the business reliably, at scale or business-ready, so the join happens in a warehouse first.
- The rate arrives by date and label, with no order or invoice to apply it to
- The data analyst links the tables by SQL keys and controls what an email may say
- Recipients get one readable message instead of a CSV to open
Bank of CanadaOfficial FX ratesEmail
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 orders and invoices
In your data warehouse the model puts the official rate table beside orders and invoices, joined by date and by currency code plus CAD (a EUR order matches EURCAD). Pick an industry to see the shape of its model.
- Every rate is quoted against the Canadian dollar, so CAD is the natural reporting basis
- Orders and invoices join on date and their currency code plus CAD, not a rate typed into a cell
- The measures, such as settled_revenue, are defined once
Bank of CanadaExchange RatesStep 3: Email Bank of Canada reports to your recipients
Add an email destination with the recipients' addresses, separated by commas, semicolons or new lines, and attach a report of the Bank of Canada Data Mart. The subject and the body are Markdown, and a table placeholder drops the rows into the body.
- The table carries date, label and rate
- Allow-list the sending address insights@e.owox.com so the message reaches inboxes
- Run it once with Create & Run report to see the email before the schedule starts
EmailWeeklyBank of Canada rates, week in reviewdatelabelrateStep 4: Schedule the Bank of Canada email and add a short analysis
Add a trigger in the report's Automate Report Runs section or on the Data Mart's Triggers tab, for example every weekday morning or Monday and Wednesday at a set hour in your time zone. Write the reading under the table.
- Send always, only when the result is not empty, or only when it is empty
- The reading is drawn from the report's fields and says only what the data shows
- Attach a pre-built Insight instead of plain text when you want it written for you
EmailBank of Canada rates, week in reviewdatelabelrateAnalysisThe official rate for each currency label, date by date.The first and last date show which label drifted in the week.Finance can restate an invoice with the rate of its own date.Step 5: Reuse Bank of Canada inside OWOX MCP
The Data Mart behind your email report also works in OWOX MCP, your assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.
- Ask in plain words; the answer comes from your data warehouse
- A Bank of Canada question worth repeating becomes the next scheduled email
Google SheetsOpen
ExcelOpen
- 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.0Start a connector run without expanding the Input Source card
- 0.35.0Resume an interrupted manual backfill from the last fully loaded date
- 0.35.0Limit manual backfill to 31 days per run
Why OWOX for Bank of Canada by email
Scheduled exports and hand-mailed screenshots put numbers in an inbox. OWOX also keeps the data yours, linked and ready to model.
- You own the data. Bank of Canada lands in your own data warehouse, in tables you control.
- Rates finance can quote. The email carries the rate with its date, so a restated invoice points at the exact number it used.
- Nothing to open. Recipients read the table and the analysis in the message, with no login to a dashboard or to OWOX.
- Same numbers everywhere. The Bank of Canada Data Mart behind the email also feeds your reports and your AI assistant.
- You set the rule. A report sends always, only when it has rows, or only when it is empty, so a quiet week does not fill inboxes.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.