--- title: "Open Exchange Rates to Databricks Connector | OWOX" canonical: "https://www.owox.com/connectors/free-open-exchange-rates-connector-to-databricks" updated: "2026-09-21" --- # Collect Open Exchange Rates Data into Databricks Own your Open Exchange Rates data in Databricks with OWOX Data Marts. Collect real-time and historical currency exchange rates into Databricks, control schema and refresh logic, and reuse the data across BI tools and AI Insights. ![](https://cdn.owox.com/www/webflow/679a01a3971c7e05d0d522c3_178.svg/public)Open Exchange R… · Connected · Historical excha… Data Mart · Published · one definition ![](https://cdn.owox.com/www/portfolio-management-connectors/databricks-connector-to-google-sheets/icon/1.png/public)Databricks · Date · Base · Curre…Daily 09:00 Refreshed on a schedule. No exports, no copy-paste. [Get Started Free](https://www.owox.com/app-signup) ## Endpoints ## Open Exchange Rates Endpoints [Documentation](https://docs.owox.com/packages/connectors/src/sources/open-exchange-rates/readme/) 1 Open Exchange Rates endpoints you can import. Each lands in its own table in your data warehouse. * [Historical exchange rates data Contains historical exchange rates for different currencies relative to a base currency 4 fields · Time series](/data-sources/open-exchange-rates#schema-historical-exchange-rates-data) ## S01 · Step 1 ## Step 1: Create a Databricks data storage Start by connecting Databricks as your [data storage](/data-storages) in OWOX Data Marts. * Provide the Databricks Workspace URL * Specify the HTTP Path for your SQL Warehouse * Add a Personal Access Token for Databricks authentication [Connect Databricks](https://www.owox.com/app-signup) ![Step 1: Create a Databricks Data Storage](https://cdn.owox.com/www/portfolio-management-connectors/free-criteo-ads-connector-to-databricks/body/1.png/public) ## S02 · Step 2 ## Step 2: Create an Open Exchange Rates Data Mart Create a new Data Mart and choose Connector as the definition type. * Select Open Exchange Rates as the data source * Provide your Open Exchange Rates API credentials * No API coding or engineering required [Add Open Exchange Rates](https://www.owox.com/app-signup) ![Step 2: Create an Open Exchange Rates Data Mart](https://cdn.owox.com/www/portfolio-management-connectors/free-open-exchange-rates-connector-to-aws-athena/body/1.png/public) ## S03 · Step 3 ## Step 3: Select fields & configure data import Choose exactly which exchange rate data you want to land in Databricks. * Select the required Open Exchange Rates API endpoint * Choose fields such as base currency, target currency, exchange rate, and timestamp * Define destination schema and table settings, or keep defaults [Choose Fields](https://www.owox.com/app-signup) ![Step 3: Select Fields & Configure Data Import](https://cdn.owox.com/www/portfolio-management-connectors/free-open-exchange-rates-connector-to-aws-athena/body/2.png/public) ## S04 · Step 4 ## Step 4: Run & schedule exchange rates data collection Once published, control how exchange rate data is imported. * Incremental load for the latest available rates * Backfill (custom period) for historical exchange rate data * Monitor execution in Run History [Run First Import](https://www.owox.com/app-signup) ![Step 4: Run & Schedule Exchange Rates Data Collection](https://cdn.owox.com/www/portfolio-management-connectors/free-open-exchange-rates-connector-to-aws-athena/body/3.png/public) ## S05 · Step 5 ## Step 5: Use exchange rates data across BI tools & AI Insights Your exchange rate data is now available through Databricks. * Normalize revenue and cost metrics across multiple currencies * Join exchange rates with ads, ecommerce, or finance datasets * Enable AI Insights for currency fluctuation summaries and alerts [Activate Reporting](https://www.owox.com/app-signup) ![Step 5: Use Exchange Rates Data Across BI Tools & AI Insights](https://cdn.owox.com/www/portfolio-management-connectors/free-open-exchange-rates-connector-to-aws-athena/body/4.png/public) ## Related connectors [Open Exchange Rates to Claude](/connectors/open-exchange-rates-connector-to-claude)[Bank of Canada to Databricks](/connectors/bank-of-canada-connector-to-databricks)[Open Holidays to Databricks](/connectors/open-holidays-connector-to-databricks)[Open Exchange Rates to ChatGPT](/connectors/open-exchange-rates-connector-to-chatgpt)[Facebook Ads to Databricks](/connectors/free-facebook-ads-connector-to-databricks)[Google Ads to Databricks](/connectors/free-google-ads-connector-to-databricks)[Microsoft Ads to Databricks](/connectors/free-microsoft-ads-connector-to-databricks)[TikTok Ads to Databricks](/connectors/free-tiktok-ads-connector-to-databricks)[Criteo Ads to Databricks](/connectors/free-criteo-ads-connector-to-databricks) · Show 6 more · Show fewer ## Recent updates * [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog/#compare-linkedin-ads-results-across-markets-spend-by-country-region-and-county-0430) * [0.43.0 · The Sheet link of a Google Sheets source opens the imported tab, not the first one](https://docs.owox.com/docs/changelog/#the-sheet-link-of-a-google-sheets-source-opens-the-imported-tab-not-the-first-one-0430) * [0.43.0 · Connect a Google Sheets plan with one Google sign-in](https://docs.owox.com/docs/changelog/#connect-a-google-sheets-plan-with-one-google-sign-in-0430) * [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410) * [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410) ## Turn Exchange Rate Data into Business Decisions Schedule a quick walkthrough to see how OWOX Data Marts helps you collect Open Exchange Rates data in Databricks, reduce reporting complexity, and scale analytics with confidence. [Get Started Free](https://www.owox.com/app-signup) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [Documentation](https://docs.owox.com/packages/connectors/src/sources/open-exchange-rates/readme) - [Historical exchange rates dataContains historical exchange rates for different currencies relative…](https://www.owox.com/data-sources/open-exchange-rates) — /data-sources/open-exchange-rates.md - [data storage](https://www.owox.com/data-storages) — /data-storages.md - [Open Exchange Rates to Claude](https://www.owox.com/connectors/open-exchange-rates-connector-to-claude) — /connectors/open-exchange-rates-connector-to-claude.md - [Bank of Canada to Databricks](https://www.owox.com/connectors/bank-of-canada-connector-to-databricks) — /connectors/bank-of-canada-connector-to-databricks.md - [Open Holidays to Databricks](https://www.owox.com/connectors/open-holidays-connector-to-databricks) — /connectors/open-holidays-connector-to-databricks.md - [Open Exchange Rates to ChatGPT](https://www.owox.com/connectors/open-exchange-rates-connector-to-chatgpt) — /connectors/open-exchange-rates-connector-to-chatgpt.md - [Facebook Ads to Databricks](https://www.owox.com/connectors/free-facebook-ads-connector-to-databricks) — /connectors/free-facebook-ads-connector-to-databricks.md - [Google Ads to Databricks](https://www.owox.com/connectors/free-google-ads-connector-to-databricks) — /connectors/free-google-ads-connector-to-databricks.md - [Microsoft Ads to Databricks](https://www.owox.com/connectors/free-microsoft-ads-connector-to-databricks) — /connectors/free-microsoft-ads-connector-to-databricks.md - [TikTok Ads to Databricks](https://www.owox.com/connectors/free-tiktok-ads-connector-to-databricks) — /connectors/free-tiktok-ads-connector-to-databricks.md - [Criteo Ads to Databricks](https://www.owox.com/connectors/free-criteo-ads-connector-to-databricks) — /connectors/free-criteo-ads-connector-to-databricks.md - [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog)