How Airbyte Works
About the source and destination
Exchange Rates Api
Databricks Lakehouse
Sync with Airbyte
Sync Manually
What sets Airbyte Apart
Modern GenAI Workflows
Move Large Volumes, Fast
An Extensible Open-Source Standard
Full Control & Security
Fully Featured & Integrated
Enterprise Support with SLAs
Used by tens of thousands of developers, Exchange Rates API provides accurate and reliable currency data instantly through its free, simple-to-use API interface. With more than 10 years of exceptional API uptime and support, developers trust Exchange Rates API to provide fast and accurate conversion rates for 160 different currencies as well as essential stock market data in JSON format. They have worked hard to achieve their mission of building a remarkably hardware efficient and reliable currency converter API.
Databricks is an American enterprise software company founded by the creators of Apache Spark. Databricks combines data warehouses and data lakes into a lakehouse architecture.
1. Go to the Airbyte dashboard and click on "Sources" on the left-hand side of the screen.
2. Click on the "Create a new source" button and select "Exchange Rates API" from the list of available connectors.
3. Enter a name for your source and click on "Next".
4. Enter your Exchange Rates API access key in the "API Key" field.
5. Select the base currency you want to use for your exchange rates in the "Base Currency" field.
6. Choose the frequency at which you want to update your exchange rates in the "Sync Frequency" field.
7. Click on "Test" to ensure that your credentials are correct and that the connection is successful.
8. If the test is successful, click on "Create" to save your source and start syncing your exchange rates data.
Note: You can also customize your source settings by selecting the tables you want to sync, setting up incremental sync, and adding filters to your data.
1. First, navigate to the Airbyte website and log in to your account.
2. Once you are logged in, click on the "Destinations" tab on the left-hand side of the screen.
3. Scroll down until you find the "Databricks Lakehouse" connector and click on it.
4. You will be prompted to enter your Databricks Lakehouse credentials, including your account name, personal access token, and workspace ID.
5. Once you have entered your credentials, click on the "Test" button to ensure that the connection is successful.
6. If the test is successful, click on the "Save" button to save your Databricks Lakehouse destination connector settings.
7. You can now use the Databricks Lakehouse connector to transfer data from your source connectors to your Databricks Lakehouse destination.
8. To set up a data transfer, navigate to the "Sources" tab and select the source connector that you want to use.
9. Follow the prompts to enter your source connector credentials and configure your data transfer settings.
10. Once you have configured your source connector, select the Databricks Lakehouse connector as your destination and follow the prompts to configure your data transfer settings.
11. Click on the "Run" button to initiate the data transfer.
With Airbyte, creating data pipelines take minutes, and the data integration possibilities are endless. Airbyte supports the largest catalog of API tools, databases, and files, among other sources. Airbyte's connectors are open-source, so you can add any custom objects to the connector, or even build a new connector from scratch without any local dev environment or any data engineer within 10 minutes with the no-code connector builder.
We look forward to seeing you make use of it! We invite you to join the conversation on our community Slack Channel, or sign up for our newsletter. You should also check out other Airbyte tutorials, and Airbyte’s content hub!
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
Ready to get started?
Frequently Asked Questions
Exchange Rates API provides access to various types of data related to currency exchange rates. The API offers real-time and historical exchange rates for over 170 currencies, including cryptocurrencies. The following are the categories of data that the Exchange Rates API provides:
• Real-time exchange rates: The API provides real-time exchange rates for various currencies, which are updated every minute.
• Historical exchange rates: The API offers historical exchange rates for up to 10 years, allowing users to analyze trends and patterns in currency exchange rates.
• Currency conversion: The API allows users to convert one currency to another using the latest exchange rates.
• Time-series data: The API provides time-series data for exchange rates, allowing users to track changes in exchange rates over time.
• Currency metadata: The API provides metadata for various currencies, including their names, symbols, and ISO codes.
• Cryptocurrency data: The API provides real-time exchange rates for various cryptocurrencies, including Bitcoin, Ethereum, and Litecoin.
Overall, the Exchange Rates API provides a comprehensive set of data related to currency exchange rates, making it a valuable resource for businesses and individuals who need to track currency exchange rates.
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey: